---
title: "EDATE and EOMONTH practice: 4 exercises with answers"
description: "Practice EDATE and EOMONTH in Excel: contract end dates, the last day of the month, the first day of next month and days in a month."
canonical_url: "https://excelsavvy.com/practice/edate-eomonth"
meta:
  "og:description": "Practice EDATE and EOMONTH in Excel: contract end dates, the last day of the month, the first day of next month and days in a month."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RURBVEUgYW5kIEVPTU9OVEggcHJhY3RpY2U6IDQgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgRURBVEUgYW5kIEVPTU9OVEggaW4gRXhjZWw6IGNvbnRyYWN0IGVuZCBkYXRlcywgdGhlIGxhc3QgZGF5IG9mIHRoZSBtb250aCwgdGhlIGZpcnN0IGRheSBvZiBuZXh0IG1vbnRoIGFuZCBkYXlzIGluIGEgbW9udGgu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIlN0YXJ0IGRhdGUiLCJNb250aHMiLCJFbmQgZGF0ZSJdfSx7Im4iOjIsImNlbGxzIjpbIk1hciAxNSwgMjAyNCIsIjEyIiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii9wcmFjdGljZS9lZGF0ZS1lb21vbnRoIg%2Cs_LfGNsaeQCHZgjFct.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "EDATE and EOMONTH practice: 4 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RURBVEUgYW5kIEVPTU9OVEggcHJhY3RpY2U6IDQgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgRURBVEUgYW5kIEVPTU9OVEggaW4gRXhjZWw6IGNvbnRyYWN0IGVuZCBkYXRlcywgdGhlIGxhc3QgZGF5IG9mIHRoZSBtb250aCwgdGhlIGZpcnN0IGRheSBvZiBuZXh0IG1vbnRoIGFuZCBkYXlzIGluIGEgbW9udGgu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIlN0YXJ0IGRhdGUiLCJNb250aHMiLCJFbmQgZGF0ZSJdfSx7Im4iOjIsImNlbGxzIjpbIk1hciAxNSwgMjAyNCIsIjEyIiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii9wcmFjdGljZS9lZGF0ZS1lb21vbnRoIg%2Cs_LfGNsaeQCHZgjFct.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **EDATE and EOMONTH practice exercises**

Move a date by whole months, and find the last or first day of a month, for contract ends, renewals and payment terms.

[**Start the first exercise**](https://excelsavvy.com/practice/edate-eomonth/edate-add-months)

DAY(EDATE(EOMONTH(

## **How EDATE and EOMONTH work**

EDATE moves a date forward or back by a whole number of months. EOMONTH finds the last day of a month, a number of months away. Both take two arguments: a start date and the number of months, where a negative number goes back in time.

`**=EDATE(A2,B2)**` adds the months in B2 to the start date in A2, so Jan 15, 2024 plus 6 months gives Jul 15, 2024. `**=EOMONTH(A2,0)**` returns the last day of the month the date is in: for Feb 10, 2024 that's Feb 29, 2024. Add 1 and `**=EOMONTH(A2,0)+1**` is the first day of the next month. `**=DAY(EOMONTH(A2,0))**` gives the number of days in the month.

Both functions return a day number, so format the result cell as a date. If a month is too short, EDATE lands on its last day: Jan 31 plus 1 month gives Feb 29 in 2024. The exercises below cover a contract end date, the last day of a month, the first day of next month and the days in a month.

1. [**1****Contract end date with EDATE**In C2, use EDATE to find the date the number of months in B2 after the start date in A2.](https://excelsavvy.com/practice/edate-eomonth/edate-add-months)
2. [**2****Last day of the month with EOMONTH****Premium**In B2, use EOMONTH to find the last day of the month of the invoice date in A2.](https://excelsavvy.com/practice/edate-eomonth/eomonth-end-of-month)
3. [**3****First day of next month****Premium**A subscription starts on the first day of the month after it is signed. In B2, find that date from A2. Take the end of the signing month with EOMONTH and add one day.](https://excelsavvy.com/practice/edate-eomonth/first-day-of-next-month)
4. [**4****Days in the month with DAY and EOMONTH****Premium**To prorate the first month's rent you need the number of days in the move-in month. In B2, take the day number of the month's last day, DAY(EOMONTH(A2,0)).](https://excelsavvy.com/practice/edate-eomonth/days-in-month)

## **Functions in this topic**

- [**DAY**](https://excelsavvy.com/functions/day)
- [**EDATE**](https://excelsavvy.com/functions/edate)
- [**EOMONTH**](https://excelsavvy.com/functions/eomonth)

## **Read the guide**

- [**Excel for finance and accounting: the skills you actually use**](https://excelsavvy.com/learn/excel-for-finance)
- [**Dates in Excel: how they work and the formulas you need**](https://excelsavvy.com/learn/excel-dates)
- [**Excel calendar 2026: build your own with week numbers and holidays**](https://excelsavvy.com/learn/excel-calendar-2026)

## **Questions**

<details>

<summary>

### How do I get the first day of the current month in Excel?

</summary>

Use =EOMONTH(A2,-1)+1. EOMONTH with -1 gives the last day of the previous month, and adding 1 moves to the first day of the month the date is in. To get the first day of today's month, replace A2 with TODAY().

</details>

<details>

<summary>

### Why does EDATE return a number like 45366?

</summary>

EDATE returns the date as a day number, and the cell has a number format. Select the cell and choose Short Date on the Home tab. 45366 is Mar 15, 2024. Nothing is wrong with the formula, only with how the cell displays the result.

</details>

<details>

<summary>

### What is the difference between EDATE and adding 30 days?

</summary>

Months have different lengths, so +30 drifts: Jan 15 plus 30 days is Feb 14, not Feb 15. EDATE keeps the same day number and moves by calendar months, so it gives Feb 15. Use EDATE for renewals and contracts that run in whole months, and +30 for terms counted in days.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/edate-eomonth#webpage","description":"Practice EDATE and EOMONTH in Excel: contract end dates, the last day of the month, the first day of next month and days in a month.","name":"EDATE and EOMONTH practice: 4 exercises with answers","url":"https://excelsavvy.com/practice/edate-eomonth","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/edate-eomonth#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/edate-eomonth#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/edate-eomonth#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/edate-eomonth#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/edate-eomonth"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/edate-eomonth#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"EDATE and EOMONTH practice: 4 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/edate-eomonth#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I get the first day of the current month in Excel?","acceptedAnswer":{"@type":"Answer","text":"Use =EOMONTH(A2,-1)+1. EOMONTH with -1 gives the last day of the previous month, and adding 1 moves to the first day of the month the date is in. To get the first day of today's month, replace A2 with TODAY()."}},{"@id":"https://excelsavvy.com/practice/edate-eomonth#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does EDATE return a number like 45366?","acceptedAnswer":{"@type":"Answer","text":"EDATE returns the date as a day number, and the cell has a number format. Select the cell and choose Short Date on the Home tab. 45366 is Mar 15, 2024. Nothing is wrong with the formula, only with how the cell displays the result."}},{"@id":"https://excelsavvy.com/practice/edate-eomonth#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"What is the difference between EDATE and adding 30 days?","acceptedAnswer":{"@type":"Answer","text":"Months have different lengths, so +30 drifts: Jan 15 plus 30 days is Feb 14, not Feb 15. EDATE keeps the same day number and moves by calendar months, so it gives Feb 15. Use EDATE for renewals and contracts that run in whole months, and +30 for terms counted in days."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
