Add or subtract dates - Microsoft Support
You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel. Suppose …
WORKDAY function - Microsoft Support
Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as …
Calculate the difference between two dates - Microsoft Support
Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following. …
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
EDATE function - Microsoft Support
Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue. EDATE (start_date, months) The EDATE function syntax has the following …
WORKDAY.INTL function - Microsoft Support
This article describes the formula syntax and usage of the WORKDAY.INTL function in Microsoft Excel. Returns the serial number of the date before or after a specified number of workdays …
NETWORKDAYS function - Microsoft Support
Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate …
DAYS360 function - Microsoft Support
The DAYS360 function returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to …
Create a list of sequential dates - Microsoft Support
You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command. Select the cell that contains the first date. Drag the fill handle across the adjacent …
DATE function - Microsoft Support
Syntax: DATE(year,month,day) For example: =DATE(C2,A2,B2) combines the year from cell C2, the month from cell A2, and the day from cell B2 and puts them into one cell as a date. The …
DAY function - Microsoft Support
Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Syntax. DAY(serial_number) The DAY function syntax has the following …