Computing 6 months ago from today, will result in the following day and date:
- It is January 18, 2026 (Sunday).
- It is the 18 day of the year.
- This day falls within the 4 week.
- After this day there are 347 days left in the year.
- It is Sunday number 4 of the year.
- This date is 0 weeks and 0 days from now.
The following table provides the date in 6 months ago from today, tomorow, or yesterday, and some additional various. If you want to calculate 6 months ago from a different date, then use our date calculator.
| Start Date | Date in -6 months |
|---|
To calculate the date and day, 6 months ago from now, the easiest way is to have a calendar. Just start with the current day, and then count 6 month backwards. For example six months ago from December 1 becomes March 1. Othewise, use a date calculator like the one on this page.
From and including: Sunday, January 18, 2026 to, but not including: Saturday, July 18, 2026, means: 180 days, which can be converted to these time units:
Within 6 months we do have 181 days.
Note: Since there are common years and leap years, the number of days in 9 months is not always the same. Moreover, some months have 28, 29, 30 or 31 days, so it depends from the day you count.
How to calculate 6 months ago from today in Excel?To simply calculate six months from today, in Excel, we do use this formula =EDATE(start_date; months). This EDATE Function used in Microsoft Excel or Google Sheets will return the end date for a specified number of months before or after a given start date.
=EDATE(TODAY(); -6)