Excel function category
Excel Date and Time Functions
Reference pages for date and time formulas used in schedules, reporting, elapsed-time calculations, and calendar-based worksheets.
12 functions
DATE
Date & Time
Build a valid Excel date from separate year, month, and day values.
Syntax
DATE(year, month, day)DATEDIF
Date & Time
Calculate the difference between two dates in years, months, days, or combinations of them.
Syntax
DATEDIF(start_date, end_date, unit)DAY
Date & Time
Return the day number from a valid Excel date.
Syntax
DAY(serial_number)EOMONTH
Date & Time
Return the last day of the month a given number of months before or after a start date.
Syntax
EOMONTH(start_date, months)MONTH
Date & Time
Return the month number from a valid Excel date.
Syntax
MONTH(serial_number)NETWORKDAYS
Date & Time
Return the number of working days between two dates.
Syntax
NETWORKDAYS(start_date, end_date, [holidays])NOW
Date & Time
Return the current date and time based on the workbook's latest recalculation.
Syntax
NOW()TIME
Date & Time
Build a valid Excel time value from hour, minute, and second components.
Syntax
TIME(hour, minute, second)TODAY
Date & Time
Return the current date as a dynamic Excel date value.
Syntax
TODAY()WEEKDAY
Date & Time
Return the day-of-week number for a valid Excel date.
Syntax
WEEKDAY(serial_number, [return_type])WORKDAY
Date & Time
Return a date that is a given number of working days before or after a start date.
Syntax
WORKDAY(start_date, days, [holidays])YEAR
Date & Time
Return the year from a valid Excel date.
Syntax
YEAR(serial_number)