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