Excel date functions
Date functions in Excel, explained with live examples.
25 date functions in Excel — 0 documented in depth so far, the rest indexed below and landing every week.
All Excel date functions
The full set — deep dives on the way.
- DATE
- Returns the serial number of a particular date
- 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.
- DATEVALUE
- Converts a date in the form of text to a serial number
- DAY
- Converts a serial number to a day of the month
- DAYS
- Returns the number of days between two dates
- DAYS360
- Calculates the number of days between two dates based on 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
- EOMONTH
- Returns the serial number of the last day of the month before or after a specified number of months
- HOUR
- Converts a serial number to an hour
- ISOWEEKNUM
- Returns the number of the ISO week number of the year for a given date
- MINUTE
- Converts a serial number to a minute
- MONTH
- Converts a serial number to a month
- NETWORKDAYS
- Returns the number of whole workdays between two dates
- NETWORKDAYS.INTL
- Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
- NOW
- Returns the serial number of the current date and time
- SECOND
- Converts a serial number to a second
- TIME
- Returns the serial number of a particular time
- TIMEVALUE
- Converts a time in the form of text to a serial number
- TODAY
- Returns the serial number of today's date
- WEEKDAY
- Converts a serial number to a day of the week
- WEEKNUM
- Converts a serial number to a number representing where the week falls numerically with a year
- WORKDAY
- Returns the serial number of the date before or after a specified number of workdays
- WORKDAY.INTL
- Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
- YEAR
- Converts a serial number to a year
- YEARFRAC
- Returns the year fraction representing the number of whole days between start_date and end_date
More Excel function categories