Build a date that stops at month-end
Turn 2026, 2 and 31 into February 28, 2026, the month's last real day.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATE(A8,B8+1,0) | Day 0 of next month: this month's last day. | November 30, 2026 |
| 2 | DAY( … ) | How many days the month has. | 30 |
| 3 | MIN(C8, … ) | The day wanted, or the last day if smaller. | 4 |
| 4 | DATE(A8,B8, … ) | Puts the year, month and day together as a date. | November 4, 2026 |
Each bracket wraps the one above it, so Excel works from the inside out.
=DATE(A8,B8,MIN(C8,DAY(DATE(A8,B8+1,0))))How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own dates. Paste the year, month and day wanted into the green columns of the Template tab. The dates fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only when your rule says to move to month-end. A wrong birth date needs checking, not changing.
Microsoft's help: DATE function
OTHER ROUTES YOU MIGHT LIKE

Count weekend days in a date range
November 4, 2026 to November 10, 2026 → 2 weekend dates
Get the template →
Count day boundaries between times
7/4/2026 11:59:59 PM to 7/5/2026 12:01:59 AM → 1
Get the template →
Write a full date with an ordinal day
November 4, 2026 → 4th November 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →