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(),-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 before other dates
| Starting from | 6 months earlier |
|---|---|
| Mon, Oct 5 (today) | Sunday, April 5, 2026 |
| Sun, Oct 4 | Saturday, April 4, 2026 |
| Sat, Oct 3 | Friday, April 3, 2026 |
| Fri, Oct 2 | Thursday, April 2, 2026 |
| Thu, Oct 1 | Wednesday, April 1, 2026 |
| Wed, Sep 30 | Monday, March 30, 2026 |
| Tue, Sep 29 | Sunday, March 29, 2026 |
Months ago
1 month agoSat, Sep 52 months agoWed, Aug 53 months agoSun, Jul 54 months agoFri, Jun 55 months agoTue, May 56 months agoSun, Apr 59 months agoMon, Jan 512 months agoSun, Oct 5, 202518 months agoSat, Apr 5, 202524 months agoSat, Oct 5, 2024
Frequently asked questions
What day is 6 months ago?
6 months ago was Sunday, April 5, 2026.
What day of the week is 6 months ago?
It was a Sunday.
What was the date 6 months ago?
Sunday, April 5, 2026. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 6 months?
183 calendar days is 26.1 weeks.