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.