First day of next month
PremiumA 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.
| 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.
It comes up in this mock test: Excel test for accounting and bookkeeping
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
Why this works
EOMONTH(A2,0) is Mar 31, 2024, the last day of the signing month. The day after the last day of a month is always the first of the next one, so +1 gives Apr 1, 2024 for any date in March.
Common mistake: Using EDATE(A2,1). That gives Apr 15, a month later on the same day, not the first of the month.
The answer
- B2
=EOMONTH(A2,0)+1