Months from today calculator
Add calendar months to today or any date. When the day doesn't exist in the target month, you get that month's last day, just like EDATE.
6 months from today is
Sunday, May 16, 2027
That's 181 days away, counting calendar months.
Quick answers
Counted from today, Monday, November 16, 2026. Each one has its own page with conversions and a spreadsheet formula.
- 1 month from today: Wednesday, December 16, 2026
- 2 months from today: Saturday, January 16, 2027
- 3 months from today: Tuesday, February 16, 2027
- 4 months from today: Tuesday, March 16, 2027
- 5 months from today: Friday, April 16, 2027
- 6 months from today: Sunday, May 16, 2027
- 7 months from today: Wednesday, June 16, 2027
- 8 months from today: Friday, July 16, 2027
- 9 months from today: Monday, August 16, 2027
- 10 months from today: Thursday, September 16, 2027
- 11 months from today: Saturday, October 16, 2027
- 12 months from today: Tuesday, November 16, 2027
- 18 months from today: Tuesday, May 16, 2028
- 24 months from today: Thursday, November 16, 2028
- 36 months from today: Friday, November 16, 2029
How it's calculated
Months are calendar months, not 30-day blocks: we keep the day number and move the month. If the target month is too short (one month after January 31, say), the date becomes that month's last day, exactly like EDATE.
In Excel or Google Sheets
- 6 months from today:
=EDATE(TODAY(), 6) - From a date in cell A1:
=EDATE(A1, 6)
More date calculators
Frequently asked questions
What happens at the end of a month?
If the day doesn't exist in the target month, we use that month's last day. One month after January 31 is February 28, or February 29 in a leap year.
Why isn't a month the same as 30 days?
Calendar months have 28 to 31 days, so six months can be anything from 181 to 184 days. We count real months, like EDATE, rather than 30-day blocks.
How do I do this in a spreadsheet?
Use =EDATE(TODAY(), 6) for six months, then format the cell as a date. With a start date in A1, it's =EDATE(A1, 6).