Date-Related Functions

Date-Related Functions

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

 Function                      Description

 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 num-
                               ber 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
                               dates

* 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:

  =TODAY()