How it's counted
Months are counted as calendar months, then the leftover days. From October 6, it is 6 full months and 0 days to April 6, 2027.
In a spreadsheet
In Excel or Google Sheets, type =EDATE(TODAY(),6) 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.
6 months after other dates
| Starting from | 6 months later |
|---|---|
| Tue, Oct 6 (today) | Tuesday, April 6, 2027 |
| Wed, Oct 7 | Wednesday, April 7, 2027 |
| Thu, Oct 8 | Thursday, April 8, 2027 |
| Fri, Oct 9 | Friday, April 9, 2027 |
| Sat, Oct 10 | Saturday, April 10, 2027 |
| Sun, Oct 11 | Sunday, April 11, 2027 |
| Mon, Oct 12 | Monday, April 12, 2027 |
Months from today
1 month from todayFri, Nov 62 months from todaySun, Dec 63 months from todayWed, Jan 6, 20274 months from todaySat, Feb 6, 20275 months from todaySat, Mar 6, 20276 months from todayTue, Apr 6, 20277 months from todayThu, May 6, 20278 months from todaySun, Jun 6, 20279 months from todayTue, Jul 6, 202710 months from todayFri, Aug 6, 202711 months from todayMon, Sep 6, 202712 months from todayWed, Oct 6, 202718 months from todayThu, Apr 6, 202824 months from todayFri, Oct 6, 202836 months from todaySat, Oct 6, 2029
Frequently asked questions
What day is 6 months from today?
6 months from today is Tuesday, April 6, 2027.
What day of the week is 6 months from today?
It is a Tuesday.
What date is 6 months from now?
Tuesday, April 6, 2027. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 6 months?
182 calendar days is 26.0 weeks.