This reference lists 28 Excel date & time functions, ordered by frequency of use, with high-frequency functions marked ⭐. Each function includes its syntax and an example.
| Function | Description | Example |
|---|---|---|
DATE ⭐ |
Returns the serial number of a particular date | =DATE(2024,1,19) — Creates a date from year, month and day, giving 2024-01-19 |
DATEDIF ⭐ |
Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age | =DATEDIF(A1,TODAY(),"y") — Returns the years between A1 and today ("y" years, "m" months, "d" days) |
DAY ⭐ |
Converts a serial number to a day of the month | =DAY(A1) — Returns the day of the month (1-31) of the date in A1 |
HOUR ⭐ |
Converts a serial number to an hour | =HOUR(NOW()) — Returns the hour (0-23) of the current time |
MONTH ⭐ |
Converts a serial number to a month | =MONTH(TODAY()) — Returns the current month (1-12) |
NOW ⭐ |
Returns the serial number of the current date and time | =NOW() — Returns the current date and time |
TIME ⭐ |
Returns the serial number of a particular time | =TIME(14,30,0) — Creates a time value from hours, minutes and seconds |
TODAY ⭐ |
Returns the serial number of today's date | =TODAY() — Returns today's date |
YEAR ⭐ |
Converts a serial number to a year | =YEAR(TODAY()) — Returns the current year |
DATEVALUE |
Converts a date in the form of text to a serial number | =DATEVALUE("2024-01-19") — Converts date text to an Excel date serial number |
DAYS |
Returns the number of days between two dates | =DAYS(B1,A1) — Returns the number of days from A1 to B1 |
DAYS360 |
Calculates the number of days between two dates based on a 360-day year | =DAYS360(A1,B1) — Returns the days between two dates using a 360-day year |
EDATE |
Returns the serial number of the date that is the indicated number of months before or after the start date | =EDATE(TODAY(),3) — Returns the date 3 months after today |
EOMONTH |
Returns the serial number of the last day of the month before or after a specified number of months | =EOMONTH(TODAY(),0) — Returns the last day of the current month |
EPOCH2DATE |
Converts a Unix timestamp to an Excel date | =EPOCH2DATE(1700000000) — Converts a Unix timestamp to an Excel date |
EPOCH2TODAY |
Returns the days elapsed since the Unix epoch (1970-01-01) to today | =EPOCH2TODAY() — Returns the days from 1970-01-01 to today |
FLOOR |
Rounds a number down, toward zero | =FLOOR(A1,"01:00") — Rounds a time down to the nearest whole hour |
ISOWEEKNUM |
Returns the number of the ISO week number of the year for a given date | =ISOWEEKNUM(TODAY()) — Returns the ISO week number of today within the year |
MINUTE |
Converts a serial number to a minute | =MINUTE(NOW()) — Returns the minutes (0-59) of the current time |
NETWORKDAYS |
Returns the number of whole workdays between two dates | =NETWORKDAYS(A1,B1) — Returns the workdays between A1 and B1, excluding weekends |
NETWORKDAYS.INTL |
Returns the number of whole workdays between two dates | =NETWORKDAYS.INTL(A1,B1,1) — Counts workdays with a custom weekend definition |
SECOND |
Converts a serial number to a second | =SECOND(NOW()) — Returns the seconds (0-59) of the current time |
TIMEVALUE |
Converts a time in the form of text to a serial number | =TIMEVALUE("14:30:00") — Converts time text to an Excel time serial number |
WEEKDAY |
Converts a serial number to a day of the week | =WEEKDAY(TODAY(),2) — Returns the day of the week of today (1 = Monday, 7 = Sunday) |
WEEKNUM |
Converts a serial number to a number representing where the week falls numerically with a year | =WEEKNUM(TODAY()) — Returns the week number of today within the year |
WORKDAY |
Returns the serial number of the date before or after a specified number of workdays | =WORKDAY(TODAY(),30) — Returns the date 30 workdays after today |
WORKDAY.INTL |
Returns the serial number of the date before or after a specified number of workdays | =WORKDAY.INTL(TODAY(),30,1) — Returns the date after N workdays with a custom weekend definition |
YEARFRAC |
Returns the year fraction representing the number of whole days between start_date and end_date | =YEARFRAC(A1,B1) — Returns the fraction of a year between A1 and B1 |
From Online Toolbox (www.vba.net)