Months ago calculator

Months ago steps back whole calendar months from today or any date and shows the date it lands on. The day number stays the same; when that day doesn't exist in the target month, you get the month's last day, the same rule as EDATE in Excel and Google Sheets.

6 months ago was

Friday, May 15, 2026

That was 184 days ago, counting calendar months.

See the full page for 6 months ago

Quick answers

Counted back from today, Sunday, November 15, 2026. Each one has its own page with conversions and a spreadsheet formula.

How it's calculated

We go back calendar months and keep the day number. When that day doesn't exist in the earlier month (six months before August 31 is in February), the date becomes that month's last day: the same as EDATE with a negative number.

In Excel or Google Sheets

6 months ago: =EDATE(TODAY(), -6)
From a date in cell A1: =EDATE(A1, -6)

More date calculators

Frequently asked questions

What if the day doesn't exist in that month?

The date moves to the month's last day. One month before March 31 is February 28, or February 29 in a leap year.

Why isn't it the same as 30 days per month?

Months have 28 to 31 days, so counting calendar months gives a different date than counting 30-day blocks.

How do I do this in a spreadsheet?

Use =EDATE(TODAY(), -6) for six months ago, and format the cell as a date.