Date & Time Functions

The functions of date and time are used to determine the current time, know the day, month and year, search for specific dates, find the difference in working days between two dates, and much more. Here are some of most common Date & Time Functions:

DATE - Returns the serial number of a stated date.

DAY - Returns the day of the indicated date. 

EDATE - Returns the serial number of a date that is one month or more before or after the indicated date.

EOMONTH - Returns the serial number of the last day of month of the indicated date.

HOUR - Returns the time for a specified time value.

MONTH - Returns the month of the indicated date.

MINUTE - Returns the minutes of a specified time value.

NOW - Gets the current date and time.

NETWORKDAYS - Returns the number of working days between two dates.

SECOND - Returns the second of a specified time value.

TODAY - Returns the date of today.

WEEKDAY - Returns the day of a stated date.

WEEKNUM - Returns the number of the week in a year that corresponds to a specified date.

WORKDAY - Returns the serial number of the working day from a specified date.

YEAR - Returns the year of the indicated date.