Skip Navigation

What Is the Date 6 Months From Today?

Counting forward 6 months from today lands you on the date shown below. The result updates automatically each day you visit, and is written here in every common format along with a calendar of the month it falls in.

6 Months From Today Is:

NOVEMBER
29

6 months from today is , which falls on a Sunday. That is 184 days (26 weeks and 2 days) from now.

The Date in Numbers

Here is the date 6 months from today written in the most widely used numeric formats, separated by dashes:

  • MM-DD-YYYY:
  • DD-MM-YYYY:
  • YYYY-MM-DD:

The same formats written with forward slashes instead:

  • MM/DD/YYYY:
  • DD/MM/YYYY:

Quick Facts About This Date

  • Day of the Week: Sunday
  • Day of the Year: 333 of 365
  • Week of the Year: 48
  • Month of the Year: 11 (November)
  • Days From Today: 184
  • Weeks From Today: 26 weeks and 2 days

November 2026 Calendar

The target date is highlighted in yellow on the calendar below so you can see exactly where 6 months from today falls within the month.

November 2026
SunMonTueWedThuFriSat
1234567
891011121314
15161718192021
22232425262728
2930

Calculating 6 Months From Today in Excel

To add 6 months to today's date automatically inside a spreadsheet, use the EDATE function together with TODAY(). Type the formula below into any empty cell and press Enter:

=EDATE(TODAY(), 6)

EDATE shifts the date forward by the number of months you specify and automatically clamps to the last valid day when the target month is shorter (for example, adding a month to January 31 returns the end of February). The cell refreshes every time the spreadsheet recalculates, so it always shows the date 6 months ahead of the current day.

Other "Months From Today" Dates

More Date & Time Calculators