Excel Date and Time Formulas
Functions for manipulating dates and times: calculations, conversions, and temporal formatting.
25 formulas
16 Beginner
9 Intermediate
0 Advanced
TODAY
Beginner
=TODAY()NOW
Beginner
=NOW()DATE
Beginner
=DATE(year, month, day)TIME
Beginner
=TIME(hour, minute, second)DATEVALUE
Beginner
=DATEVALUE(date_text)TIMEVALUE
Beginner
=TIMEVALUE(time_text)YEAR
Beginner
=YEAR(serial_number)MONTH
Beginner
=MONTH(serial_number)DAY
Beginner
=DAY(serial_number)HOUR
Beginner
=HOUR(serial_number)MINUTE
Beginner
=MINUTE(serial_number)SECOND
Beginner
=SECOND(serial_number)WEEKDAY
Beginner
=WEEKDAY(serial_number, [return_type])WEEKNUM
Intermediate
=WEEKNUM(serial_number, [return_type])ISOWEEKNUM
Intermediate
=ISOWEEKNUM(date)DATEDIF
Intermediate
=DATEDIF(start_date, end_date, unit)DAYS
Beginner
=DAYS(end_date, start_date)DAYS360
Intermediate
=DAYS360(start_date, end_date, [method])NETWORKDAYS
Intermediate
=NETWORKDAYS(start_date, end_date, [holidays])NETWORKDAYS.INTL
Intermediate
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])WORKDAY
Intermediate
=WORKDAY(start_date, days, [holidays])WORKDAY.INTL
Intermediate
=WORKDAY.INTL(start_date, days, [weekend], [holidays])EDATE
Beginner
=EDATE(start_date, months)EOMONTH
Beginner
=EOMONTH(start_date, months)YEARFRAC
Intermediate
=YEARFRAC(start_date, end_date, [basis])