---
title: "First day of next month | PracticeExcel"
description: "Practice EOMONTH in a live spreadsheet: find the first day of the month after a date."
canonical_url: "https://practiceexcelonline.com/practice/edate-eomonth/first-day-of-next-month"
locale: en
meta:
  "og:description": "Practice EOMONTH in a live spreadsheet: find the first day of the month after a date."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_First%2Bday%2Bof%2Bnext%2Bmonth%2Cdescription_~UHJhY3RpY2UgRU9NT05USCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQ6IGZpbmQgdGhlIGZpcnN0IGRheSBvZiB0aGUgbW9udGggYWZ0ZXIgYSBkYXRlLg%2Ceyebrow_EDATE%2Band%2BEOMONTH%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiU2lnbmVkIiwiU3RhcnRzIl19LHsibiI6MiwiY2VsbHMiOlsiTWFyIDE1LCAyMDI0IiwiIl19XSwidGFyZ2V0IjpbMSwxXX19%2Cp_Ii9wcmFjdGljZS9lZGF0ZS1lb21vbnRoL2ZpcnN0LWRheS1vZi1uZXh0LW1vbnRoIg%2Cs_YM2VFoEoWB-_fBRD.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "First day of next month | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_First%2Bday%2Bof%2Bnext%2Bmonth%2Cdescription_~UHJhY3RpY2UgRU9NT05USCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQ6IGZpbmQgdGhlIGZpcnN0IGRheSBvZiB0aGUgbW9udGggYWZ0ZXIgYSBkYXRlLg%2Ceyebrow_EDATE%2Band%2BEOMONTH%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiU2lnbmVkIiwiU3RhcnRzIl19LHsibiI6MiwiY2VsbHMiOlsiTWFyIDE1LCAyMDI0IiwiIl19XSwidGFyZ2V0IjpbMSwxXX19%2Cp_Ii9wcmFjdGljZS9lZGF0ZS1lb21vbnRoL2ZpcnN0LWRheS1vZi1uZXh0LW1vbnRoIg%2Cs_YM2VFoEoWB-_fBRD.png"
---

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

# **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.

B2fx

|  | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Signed | Starts |  |  |  | |
| 2 | Mar 15, 2024 |  |  |  |  | |
| 3 |  |  |  |  |  | |
| 4 |  |  |  |  |  | |
| 5 |  |  |  |  |  | |
| 6 |  |  |  |  |  | |
| 7 |  |  |  |  |  | |
| 8 |  |  |  |  |  | |

**Premium lesson**

## **Unlock EDATE and EOMONTH and every other lesson**

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:**NETWORKDAYS, WORKDAY and WEEKDAY****DATEDIF**

It comes up in this mock test: [**Excel test for accounting and bookkeeping**](https://practiceexcelonline.com/tests/excel-test-for-accountants)

[**See plans, from $5/month**](https://practiceexcelonline.com/pricing) [**Already premium? Sign in**](https://practiceexcelonline.com/login?next=/practice/edate-eomonth/first-day-of-next-month)

Need help?

```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/first-day-of-next-month#webpage","description":"Practice EOMONTH in a live spreadsheet: find the first day of the month after a date.","name":"First day of next month","url":"https://practiceexcelonline.com/practice/edate-eomonth/first-day-of-next-month","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/edate-eomonth/first-day-of-next-month#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/practice/edate-eomonth/first-day-of-next-month#/schema/question/1"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/edate-eomonth/first-day-of-next-month"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/edate-eomonth/first-day-of-next-month#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","item":"https://practiceexcelonline.com/practice/edate-eomonth","position":3},{"@type":"ListItem","name":"First day of next month","position":4}]},{"@id":"https://practiceexcelonline.com/practice/edate-eomonth/first-day-of-next-month#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I get the first day of the next month in Excel?","acceptedAnswer":{"@type":"Answer","text":"=EOMONTH(A2,0)+1 takes the last day of A2's month and adds one day."}},{"@id":"https://practiceexcelonline.com/practice/edate-eomonth/first-day-of-next-month#/schema/learning-resource/1","@type":"LearningResource","description":"Practice EOMONTH in a live spreadsheet: find the first day of the month after a date.","educationalLevel":"intermediate","isAccessibleForFree":false,"learningResourceType":"exercise","name":"First day of next month","teaches":"EDATE and EOMONTH"},{"@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.