Keep a date inside an allowed window
Dates before the earliest allowed date move up. Dates after the latest move back.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | MIN(A8,C8) | The proposed date, or the latest date if earlier. | November 4, 2026 |
| 2 | B8 | The earliest allowed date. | 10/28/2026 |
| 3 | MAX( … ) | The later of the two, so never too early. | November 4, 2026 |
MIN works first, inside MAX. A date already inside the window stays the same.
=MAX(B8,MIN(A8,C8))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 proposed, earliest and latest dates 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
Check that each earliest date comes before its latest date. Use this for scheduling rules, not to change real dates like birthdays.
Microsoft's help: MIN function
OTHER ROUTES YOU MIGHT LIKE

Roll weekend dates forward to Monday
Saturday July 4, 2026 → Monday July 6, 2026
Get the template →
Roll weekend dates back to Friday
Sunday May 31, 2026 → Friday May 29, 2026
Get the template →
Get the first chosen weekday of a month
November 4, 2026 + weekday 1 → Monday November 2, 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →