What Is the Date 18 Months From Today?

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

18 Months From Today Is:

Monday, November 29, 2027

18 months from today is November 29th, 2027, which falls on a Monday. That is 549 days (78 weeks and 3 days) from now.

The Date in Numbers

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

MM-DD-YYYY: 11-29-2027
DD-MM-YYYY: 29-11-2027
YYYY-MM-DD: 2027-11-29

The same formats written with forward slashes instead:

MM/DD/YYYY: 11/29/2027
DD/MM/YYYY: 29/11/2027

Quick Facts About This Date

Day of the Week: Monday
Day of the Year: 333 of 365
Week of the Year: 48
Month of the Year: 11 (November)
Days From Today: 549
Weeks From Today: 78 weeks and 3 days

November 2027 Calendar

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

Calendar for NOVEMBER 2027
November 2027
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30

Calculating 18 Months From Today in Excel

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

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