Date and time

This page lists the built-in Excel Date and Time Functions, which can be used to extract information from, and perform operations on, Excel dates and times.

FunctionPurposeParam,Optional
DATE Create a valid date from year, month, and day year month day
DATEDIF Get days, months, or years between two dates start_date end_date unit
DATEVALUE Convert a date in text format to a valid date date_text
DAY Get the day as a number (1-31) from a date date
DAYS Get days between dates end_date start_date
DAYS360 Get days between 2 dates in a 360-day year start_date end_datemethod
EDATE Get the same date in future or past months start_date months
EOMONTH Get the last day of the month in future or past months start_date months
HOUR Get the hour as a number (0-23) from a Time serial_number
ISOWEEKNUM Get ISO week number for a given date date
MINUTE Get the minute as a number (0-59) from a time serial_number
MONTH Get the month as a number (1-12) from a date date
NETWORKDAYS Get the number of working days between two dates start_date end_dateholidays
NETWORKDAYS.INTL Get work days between two dates start_date end_dateweekend holidays
NOW Get the current date and time
SECOND Get the Second as a number (0-59) from a Time serial_number
TIME Create a time with hours, minutes, and seconds hour minute second
TIMEVALUE Get a valid time from a text string time_text
TODAY Get the current date
WEEKDAY Get the day of the week as a number serial_numberreturn_type
WEEKNUM Get the week number for a given date serial_numreturn_type
WORKDAY Get a date n working days in the future or past start_date daysholidays
WORKDAY.INTL Get date and working days in future or past start_date daysweekend holidays
YEAR Get the year from a date date
YEARFRAC Get the fraction of a year between two dates start_date end_datebasis