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
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