How it's counted
Months are counted as calendar months, then the leftover days. From October 13, it is 21 full months and 0 days to July 13, 2028.
In a spreadsheet
In Excel or Google Sheets, type =EDATE(TODAY(),21) 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.
21 months after other dates
| Starting from | 21 months later |
|---|---|
| Tue, Oct 13 (today) | Thursday, July 13, 2028 |
| Wed, Oct 14 | Friday, July 14, 2028 |
| Thu, Oct 15 | Saturday, July 15, 2028 |
| Fri, Oct 16 | Sunday, July 16, 2028 |
| Sat, Oct 17 | Monday, July 17, 2028 |
| Sun, Oct 18 | Tuesday, July 18, 2028 |
| Mon, Oct 19 | Wednesday, July 19, 2028 |
Months from today
Frequently asked questions
What day is 21 months from today?
21 months from today is Thursday, July 13, 2028.
What day of the week is 21 months from today?
It is a Thursday.
What date is 21 months from now?
Thursday, July 13, 2028. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 21 months?
639 calendar days is 91.3 weeks.
What date was 21 months ago?
Monday, January 13, 2025.
Does "21 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 21 months from today in Excel or Google Sheets?
Type =TODAY()+639 and format the cell as a date, or use =EDATE(TODAY(),21).
How many business days are in 21 months?
From today it is 457 weekdays (Monday to Friday), before public holidays.