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(),-36) 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.
36 months before other dates
| Starting from | 36 months earlier |
|---|---|
| Tue, Oct 13 (today) | Friday, October 13, 2023 |
| Mon, Oct 12 | Thursday, October 12, 2023 |
| Sun, Oct 11 | Wednesday, October 11, 2023 |
| Sat, Oct 10 | Tuesday, October 10, 2023 |
| Fri, Oct 9 | Monday, October 9, 2023 |
| Thu, Oct 8 | Sunday, October 8, 2023 |
| Wed, Oct 7 | Saturday, October 7, 2023 |
Months ago
Frequently asked questions
What day is 36 months ago?
36 months ago was Friday, October 13, 2023.
What day of the week is 36 months ago?
It was a Friday.
What was the date 36 months ago?
Friday, October 13, 2023. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 36 months?
1,096 calendar days is 156.6 weeks.
What date is 36 months from today?
Saturday, October 13, 2029.
Does "36 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 36 months ago in Excel or Google Sheets?
Type =TODAY()-1096 and format the cell as a date, or use =EDATE(TODAY(),-36).
How many business days are in 36 months?
From today it is 782 weekdays (Monday to Friday), before public holidays.