Date & Time Functions

Assembles a date from year, month, and day values.

Returns the difference between two dates in years, months, or days.

DAY returns the day number (1-31) from a date.

Counts the days from start_date to end_date.

Shifts a date by a number of months.

Returns the last day of the month offset by n months.

Returns the hour portion (0-23) of a time value.

Returns the minute portion (0-59) of a time value.

MONTH returns the month (1-12) from a date.

Counts workdays between two dates.

Counts workdays between two dates with a custom weekend.

NOW displays the current date and time, updating automatically.

Returns the second portion (0-59) of a time value.

Converts hour, minute, and second into a time fraction of a day.

TODAY displays today's date, updating automatically when the workbook opens or recalculates.

Returns the day-of-week number for a date.

Returns the week-of-year number for a date.

Returns a date n workdays from a start date.

Returns a date n workdays away with a custom weekend.

YEAR returns the year component of a date.