How it's counted
Months are counted as calendar months, then the leftover days. From October 13, it is 15 full months and 0 days to January 13, 2028.
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 after other dates
| Starting from | 15 months later |
|---|---|
| Tue, Oct 13 (today) | Thursday, January 13, 2028 |
| Wed, Oct 14 | Friday, January 14, 2028 |
| Thu, Oct 15 | Saturday, January 15, 2028 |
| Fri, Oct 16 | Sunday, January 16, 2028 |
| Sat, Oct 17 | Monday, January 17, 2028 |
| Sun, Oct 18 | Tuesday, January 18, 2028 |
| Mon, Oct 19 | Wednesday, January 19, 2028 |
Months from today
Frequently asked questions
What day is 15 months from today?
15 months from today is Thursday, January 13, 2028.
What day of the week is 15 months from today?
It is a Thursday.
What date is 15 months from now?
Thursday, January 13, 2028. 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 was 15 months ago?
Sunday, July 13, 2025.
Does "15 months from today" 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 from today 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 327 weekdays (Monday to Friday), before public holidays.