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