Get the First Day of the Next Month

Excel & Google Sheets

How it works

EOMONTH(A2,0) finds the last day of the date's month, and adding 1 steps over the boundary to the 1st of the next month — 8 July 2026 becomes 31 July, plus one day is 1 August. Because dates are numbers, the +1 is ordinary arithmetic, and it handles every edge automatically: month lengths, year-end (15 December rolls to 1 January 2027), and leap Februaries. The same pattern generalizes — =EOMONTH(A2,1)+1 gives the 1st of the month after next, and =EOMONTH(A2,-1)+1 gives the 1st of the *current* month, useful as a period-start anchor in reports.

EOMONTH(A2,0)

The last day of A2's month — e.g. 2026-07-31.

+1

One day past month end is always the 1st of the next month.

When to use it

Use it for subscription billing starts, rent or lease periods beginning on the 1st, contract effective dates at the next month boundary, and report period anchors.

Common mistakes

• ✕Putting the +1 inside EOMONTH.

  ✓=EOMONTH(A2,0+1) or =EOMONTH(A2,1) returns the end of *next* month. The +1 must sit outside the function, adding one day to the month-end date.

• ✕Building it with DATE(YEAR(A2),MONTH(A2)+1,1) and worrying about December.

  ✓That version actually works — DATE rolls month 13 into January — but it's longer and easier to mistype. EOMONTH(A2,0)+1 is the idiomatic form.

• ✕The result shows a number like 46235.

  ✓That's the date serial — format the cell as a date to see 2026-08-01.