Goal: Jump 1 Month from Jan 31.
EOMONTH: Goes to the very last day.
EDATE: Tries to keep the same day (clamps if needed).
Ready...
💻 Formula Structure
=EOMONTH(start_date, months)
- 1. Start Date: The reference date.
- 2. Months: Months to add/subtract (0 = Current Month).
- Result: Always the Last Day of that month.
=EDATE(start_date, months)
- 1. Start Date: The reference date.
- 2. Months: Months to add/subtract.
- Result: Same day number (e.g. 15th to 15th).
-- Select a function...
...
⚠️ Common Pitfalls
💡 First Day of Next Month?
Excel doesn't have a "First Day" function. Use this trick:
=EOMONTH(A1, 0) + 1
(Go to end of current month, then add 1 day).
📅 Short Months
EDATE("Jan 31", 1) cannot return "Feb 31". It clamps to Feb 28 (or 29 in leap years). It handles the math for you.