---
title: "EDATE and EOMONTH practice exercises | PracticeExcel"
description: "Practice EDATE and EOMONTH in a live spreadsheet with contract and payment dates."
canonical_url: "https://practiceexcelonline.com/practice/edate-eomonth"
locale: en
meta:
  "og:description": "Practice EDATE and EOMONTH in a live spreadsheet with contract and payment dates."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_EDATE%2Band%2BEOMONTH%2Bpractice%2Bexercises%2Cdescription_Practice%2BEDATE%2Band%2BEOMONTH%2Bin%2Ba%2Blive%2Bspreadsheet%2Bwith%2Bcontract%2Band%2Bpayment%2Bdates.%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIlN0YXJ0IGRhdGUiLCJNb250aHMiLCJFbmQgZGF0ZSJdfSx7Im4iOjIsImNlbGxzIjpbIk1hciAxNSwgMjAyNCIsIjEyIiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii9wcmFjdGljZS9lZGF0ZS1lb21vbnRoIg%2Cs_SKUsO8UG-S_MNuYn.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "EDATE and EOMONTH practice exercises | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_EDATE%2Band%2BEOMONTH%2Bpractice%2Bexercises%2Cdescription_Practice%2BEDATE%2Band%2BEOMONTH%2Bin%2Ba%2Blive%2Bspreadsheet%2Bwith%2Bcontract%2Band%2Bpayment%2Bdates.%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIlN0YXJ0IGRhdGUiLCJNb250aHMiLCJFbmQgZGF0ZSJdfSx7Im4iOjIsImNlbGxzIjpbIk1hciAxNSwgMjAyNCIsIjEyIiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii9wcmFjdGljZS9lZGF0ZS1lb21vbnRoIg%2Cs_SKUsO8UG-S_MNuYn.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.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://practiceexcelonline.com/practice/edate-eomonth/edate-add-months)

DAY(EDATE(EOMONTH(

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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.com/practice/edate-eomonth/days-in-month)

## **Functions in this topic**

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

## **Read the guide**

- [**Excel for finance and accounting: the skills you actually use**](https://practiceexcelonline.com/learn/excel-for-finance)
- [**Dates in Excel: how they work and the formulas you need**](https://practiceexcelonline.com/learn/excel-dates)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/practice/edate-eomonth#webpage","description":"Practice EDATE and EOMONTH in a live spreadsheet with contract and payment dates.","name":"EDATE and EOMONTH practice exercises","url":"https://practiceexcelonline.com/practice/edate-eomonth","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/edate-eomonth#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/edate-eomonth"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/edate-eomonth#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"EDATE and EOMONTH practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

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