# Date formulas in Excel and Google Sheets

> Days between dates, working days, ages, month ends, quarters and adding months. 6 answers, each checked by running it.

Source: https://spreadsheetpractice.com/formulas/topic/date · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on October 29, 2026

## Answers

- [How to calculate the number of days between two dates in Excel](https://spreadsheetpractice.com/formulas/days-between-two-dates): Subtract the earlier date from the later one: =C2-B2. Dates are numbers of days, so the difference is the number of days. `=C2-B2`
- [How to count working days between two dates in Excel](https://spreadsheetpractice.com/formulas/working-days-between-two-dates): Use =NETWORKDAYS(start, end, holidays). It counts Monday to Friday, both ends included, and skips any dates listed as holidays. `=NETWORKDAYS(B2,C2,$F$2:$F$3)`
- [How to calculate age from a date of birth in Excel](https://spreadsheetpractice.com/formulas/calculate-age-from-date-of-birth): Use =DATEDIF(birth_date, as_of_date, "y"). It returns completed years, so the age only goes up on the birthday. `=DATEDIF(B2,$F$1,"y")`
- [How to add months to a date in Excel](https://spreadsheetpractice.com/formulas/add-months-to-a-date): Use =EDATE(start_date, months). It moves the date by whole months and handles month ends correctly. `=EDATE(B2,C2)`
- [How to get the last day of the month in Excel](https://spreadsheetpractice.com/formulas/last-day-of-the-month): Use =EOMONTH(date, 0). The 0 means this month; 1 is next month and -1 is last month. `=EOMONTH(B2,0)`
- [How to get the month name from a date in Excel](https://spreadsheetpractice.com/formulas/get-month-name-from-a-date): Use =TEXT(date,"mmmm") for the full name or "mmm" for the short one. `=TEXT(A2,"mmmm")`

More topics: [Counting formulas](https://spreadsheetpractice.com/formulas/topic/count) · [Sum formulas](https://spreadsheetpractice.com/formulas/topic/sum) · [Lookup formulas](https://spreadsheetpractice.com/formulas/topic/lookup) · [IF and logic formulas](https://spreadsheetpractice.com/formulas/topic/logic) · [Text formulas](https://spreadsheetpractice.com/formulas/topic/text) · [Dynamic array formulas](https://spreadsheetpractice.com/formulas/topic/dynamic) · [Duplicates and data cleanup formulas](https://spreadsheetpractice.com/formulas/topic/cleanup) · [Rounding and math formulas](https://spreadsheetpractice.com/formulas/topic/math) · [Percentage formulas](https://spreadsheetpractice.com/formulas/topic/percent)

Every answer: [Formula answers](https://spreadsheetpractice.com/formulas). Formulas used: `DAYS`, `NETWORKDAYS`, `DATEDIF`, `EDATE`, `EOMONTH`, `TEXT`

---

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