Microsoft Office Tutorials and References
In Depth Information
Excel has quite a few functions that work with dates. They are all listed under the Date & Time
drop-down list in the Formulas
Function Library group.
Table 6-4 summarizes the date-related functions available in Excel.
Table 6-4: Date-Related Functions
DATE Returns the serial number of a date given the year, month, and day
DATEDIF Calculates the number of days, months, or years between two dates
DATEVALUE Converts a date in the form of text to an actual date
DAY Returns the day of the month for a given date
DAYS360 Calculates the number of days between two dates based on a 360-day year
EDATE* Returns the date that represents the indicated number of months before or
after the start date
EOMONTH* Returns the date of the last day of the month before or after a specified
number of months
MONTH Returns the month for a given date
NETWORKDAYS* Returns the number of whole work days between two dates
NETWORKDAYS.INTL** An international version of the NETWORKDAYS function
NOW Returns the current date and time
TODAY Returns today’s date
WEEKDAY Returns the day of the week (expressed as a number) for a date
WEEKNUM* Returns the week number of the year for a date
WORKDAY* Returns the date before or after a specified number of workdays
WORKDAY.INTL** An international version of the WORKDAY function
YEAR Returns the year for a given date
YEARFRAC* Returns the year fraction representing the number of whole days between two
* In versions prior to Excel 2007, this function is available only when the Analysis ToolPak add-in is installed.
** Indicates a function that’s new to Excel 2010.
Displaying the current date
The following function displays the current date in a cell: