Date and Time Functions

DATE

This function returns the DateTime object for a particular date, specified by the year, month, and day.

DATEDIF

This function returns the number of days, months, or years between two dates.

DATEPART

This function returns the Date object for a particular date, specified by the year, month, and day.

DATEVALUE

This function returns a DateTime object of the specified date.

DAY

This function returns the day number of the month (integer 1 to 31) that corresponds to the specified date.

DAYS

This function returns the number of days between two dates.

DAYS360

This function returns the number of days between two dates based on a 360-day year.

EDATE

This function calculates the date which is the indicated number of months before or after a specified date.

EOMONTH

This function calculates the date for the last day of the month (end of the month) which is the indicated number of months before or after the starting date.

HOUR

This function returns the hour that corresponds to a specified time.

ISOWEEKNUM

This function returns the number of the ISO week number of the year for a given date.

MINUTE

This function returns the minute corresponding to a specified time.

MONTH

This function returns the month corresponding to the specified date value.

NETWORKDAYS

This function returns the total number of complete working days between the start and end dates.

NETWORKDAYS.INTL

This function returns the number of workdays between two dates using arguments to indicate holidays and weekend days.

NOW

This function returns the current date and time.

SECOND

This function returns the seconds (0 to 59) value for a specified time.

TIME

This function returns the TimeSpan object for a specified time.

TIMEVALUE

This function returns the TimeSpan object of the time represented by a text string.

TODAY

This function returns the date and time of the current date.

WEEKDAY

This function returns the number corresponding to the day of the week for a specified date.

WEEKNUM

This function returns a number that indicates the week of the year numerically.

WORKDAY

This function returns the number of working days before or after the starting date.

WORKDAY.INTL

This function returns the serial number of the date before or after several workdays with custom weekend parameters. These parameters indicate weekend days and holidays.

YEAR

This function returns the year as an integer for a specified date.

YEARFRAC

This function returns the fraction of the year represented by the number of whole days between the start and end dates.