Advanced Excel - Date & Time Functions

Excel Date and Time functions can be used to extract information from, and perform operations on, Excel Dates and Times.

Some of the Excel Date & Time functions are new to Excel 2010 or Excel 2013, so are not available in earlier versions of Excel. You can find this information in the applicability section of the function.

Date and Time Functions

The following table lists all the Date & Time functions −

S.No. Function and Description
1 DATE

Returns the serial number of a particular date.

2 DATEDIF

Calculates the number of days, months, or years between two dates.

3 DATEVALUE

Converts a date in the form of text to a serial number.

4 DAY

Converts a serial number to a day of the month.

5 DAYS

Returns the number of days between two dates.

6 DAYS360

Calculates the number of days between two dates, based on a 360-day year.

7 EDATE

Returns the serial number of the date that is the indicated number of months before or after the start date.

8 EOMONTH

Returns the serial number of the last day of the month before or after a specified number of months.

9 HOUR

Converts a serial number to an hour.

10 ISOWEEKNUM

Returns the number of the ISO week number of the year for a given date.

11 MINUTE

Converts a serial number to a minute.

12 MONTH

Converts a serial number to a month.

13 NETWORKDAYS

Returns the number of whole workdays between two dates.

14 NETWORKDAYS.INTL

Returns the number of whole workdays between two dates (international version).

15 NOW

Returns the serial number of the current date and time.

16 SECOND

Converts a serial number to a second.

17 TIME

Returns the serial number of a particular time.

18 TIMEVALUE

Converts a time in the form of text to a serial number.

19 TODAY

Returns the serial number of today’s date.

20 WEEKDAY

Converts a serial number to a day of the week.

21 WEEKNUM

Returns the week number in the year.

22 WORKDAY

Returns the serial number of the date before or after a specified number of workdays.

23 WORKDAY.INTL

Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.

24 YEAR

Converts a serial number to a year.

25 YEARFRAC

Returns the year fraction representing the number of whole days between start_date and end_date.