How it's counted
Days since are counted from the date to today, not including the date itself.
In a spreadsheet
In Excel or Google Sheets, type =EDATE(TODAY(),-7) and format the cell as a date. EDATE keeps the same day of the month, or uses the last day when that month is shorter. To count from a different start date, use the date calculator.
7 months before other dates
| Starting from | 7 months earlier |
|---|---|
| Tue, Oct 13 (today) | Friday, March 13, 2026 |
| Mon, Oct 12 | Thursday, March 12, 2026 |
| Sun, Oct 11 | Wednesday, March 11, 2026 |
| Sat, Oct 10 | Tuesday, March 10, 2026 |
| Fri, Oct 9 | Monday, March 9, 2026 |
| Thu, Oct 8 | Sunday, March 8, 2026 |
| Wed, Oct 7 | Saturday, March 7, 2026 |
Months ago
Frequently asked questions
What day is 7 months ago?
7 months ago was Friday, March 13, 2026.
What day of the week is 7 months ago?
It was a Friday.
What was the date 7 months ago?
Friday, March 13, 2026. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 7 months?
214 calendar days is 30.6 weeks.
What date is 7 months from today?
Thursday, May 13, 2027.
Does "7 months ago" include today?
No. Today is day 0, so the count starts from tomorrow (or yesterday, for dates in the past).
How do I work out 7 months ago in Excel or Google Sheets?
Type =TODAY()-214 and format the cell as a date, or use =EDATE(TODAY(),-7).
How many business days are in 7 months?
From today it is 152 weekdays (Monday to Friday), before public holidays.