# Excel date functions

> Excel stores every date as a number: a count of days in which January 1, 1900 is day 1.

Source: https://spreadsheetpractice.com/functions/category/date · Updated October 29, 2026

Excel stores every date as a number: a count of days in which January 1, 1900 is day 1. That is why you can subtract one date from another, add 30 to get a due date, or sort a column chronologically. Date functions build dates from parts, pull parts back out, and move by months or working days so you don't have to count calendars by hand.

## Which one to use

| You want to | Use | Why |
|---|---|---|
| Build a real date from a year, month and day | [DATE](https://spreadsheetpractice.com/functions/date) | Handles month and day overflow for you, so DATE(2026,13,1) becomes January 1, 2027. |
| Add or subtract whole months | [EDATE](https://spreadsheetpractice.com/functions/edate) | Keeps the day of the month and clamps to the month's last day when it has to. |
| Get the last day of a month | [EOMONTH](https://spreadsheetpractice.com/functions/eomonth) | The standard way to find month-end for billing, reporting and due dates. |
| Count working days between two dates | [NETWORKDAYS](https://spreadsheetpractice.com/functions/networkdays) | Skips weekends and an optional list of holidays. |
| Find a deadline a number of working days away | [WORKDAY](https://spreadsheetpractice.com/functions/workday) | Moves forward or back by business days, skipping weekends and holidays. |
| Calculate age or tenure in whole years | [DATEDIF](https://spreadsheetpractice.com/functions/datedif) | Counts complete years, months or days between two dates. |

## All 24 date functions

| Function | What it does | Available in |
|---|---|---|
| [DATE](https://spreadsheetpractice.com/functions/date) | DATE builds a real date from a year, month and day. | Every current version |
| [DATEDIF](https://spreadsheetpractice.com/functions/datedif) | DATEDIF counts the complete years, months or days between two dates. | Every current version |
| [DATEVALUE](https://spreadsheetpractice.com/functions/datevalue) | DATEVALUE converts a date that is stored as text into a real date that Excel can sort, subtract and format. | Every current version |
| [DAY](https://spreadsheetpractice.com/functions/day) | DAY returns the day of the month from a date, as a number from 1 to 31. | Every current version |
| [DAYS](https://spreadsheetpractice.com/functions/days) | DAYS returns the number of days between two dates. | Excel 2013 and later |
| [EDATE](https://spreadsheetpractice.com/functions/edate) | EDATE returns the date a given number of months before or after a start date, keeping the same day of the month. | Every current version |
| [EOMONTH](https://spreadsheetpractice.com/functions/eomonth) | EOMONTH returns the last day of the month a number of months before or after a date. | Every current version |
| [HOUR](https://spreadsheetpractice.com/functions/hour) | HOUR returns the hour of a time as a number from 0 to 23, so 1:45 PM gives 13. | Every current version |
| [ISOWEEKNUM](https://spreadsheetpractice.com/functions/isoweeknum) | ISOWEEKNUM returns the ISO 8601 week number of a date: weeks start on Monday, and week 1 is the week that contains the year's first Thursday. | Excel 2013 and later |
| [MINUTE](https://spreadsheetpractice.com/functions/minute) | MINUTE returns the minutes part of a time as a number from 0 to 59, so 1:45 PM gives 45. | Every current version |
| [MONTH](https://spreadsheetpractice.com/functions/month) | MONTH returns the month of a date as a number from 1 to 12. | Every current version |
| [NETWORKDAYS](https://spreadsheetpractice.com/functions/networkdays) | NETWORKDAYS counts the working days between two dates, Monday to Friday, including both the start and end date. | Every current version |
| [NETWORKDAYS.INTL](https://spreadsheetpractice.com/functions/networkdays-intl) | NETWORKDAYS.INTL counts the working days between two dates, like NETWORKDAYS, but lets you say which days are the weekend: Friday and Saturday, Sunday only, or any pattern written as a seven-character string such as "0000011". | Excel 2010 and later |
| [NOW](https://spreadsheetpractice.com/functions/now) | NOW returns the current date and time, and updates whenever the workbook recalculates. | Every current version |
| [SECOND](https://spreadsheetpractice.com/functions/second) | SECOND returns the seconds part of a time as a number from 0 to 59. | Every current version |
| [TIME](https://spreadsheetpractice.com/functions/time) | TIME builds a time from hours, minutes and seconds, such as TIME(13,30,0) for 1:30 PM. | Every current version |
| [TIMEVALUE](https://spreadsheetpractice.com/functions/timevalue) | TIMEVALUE converts a time written as text, such as "1:30 PM" or "13:30", into a real time you can add, subtract and format. | Every current version |
| [TODAY](https://spreadsheetpractice.com/functions/today) | TODAY returns the current date, with no time attached, and updates every time the workbook recalculates. | Every current version |
| [WEEKDAY](https://spreadsheetpractice.com/functions/weekday) | WEEKDAY returns the day of the week for a date as a number. | Every current version |
| [WEEKNUM](https://spreadsheetpractice.com/functions/weeknum) | WEEKNUM returns the week number of a date in its year, 1 to 54. | Every current version |
| [WORKDAY](https://spreadsheetpractice.com/functions/workday) | WORKDAY returns the date a given number of working days before or after a start date, skipping weekends and any holidays you list. | Every current version |
| [WORKDAY.INTL](https://spreadsheetpractice.com/functions/workday-intl) | WORKDAY.INTL returns the date a number of working days before or after a start date, skipping the weekend days you choose and any holidays. | Excel 2010 and later |
| [YEAR](https://spreadsheetpractice.com/functions/year) | YEAR returns the four-digit year from a date. | Every current version |
| [YEARFRAC](https://spreadsheetpractice.com/functions/yearfrac) | YEARFRAC returns the fraction of a year between two dates, such as 0.5 for six months. | Every current version |

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
