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)