Skip Navigation

What Is the Date 5 Months From Today?

Counting forward 5 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.

5 Months From Today Is:

OCTOBER
29

5 months from today is , which falls on a Thursday. That is 153 days (21 weeks and 6 days) from now.

The Date in Numbers

Here is the date 5 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: Thursday
  • Day of the Year: 302 of 365
  • Week of the Year: 44
  • Month of the Year: 10 (October)
  • Days From Today: 153
  • Weeks From Today: 21 weeks and 6 days

October 2026 Calendar

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

October 2026
SunMonTueWedThuFriSat
123
45678910
11121314151617
18192021222324
25262728293031

Calculating 5 Months From Today in Excel

To add 5 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(), 5)

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 5 months ahead of the current day.

Other "Months From Today" Dates

More Date & Time Calculators