What date is 5 months from today?
Find out which date will be 5 months from now. When is today plus 5 months. The calculator adds or subtracts days, weeks, months and years from now.
Today is August 31, 2025.
5 months from today will be:
Saturday, January 31, 2026
31th day of of winter, 31th day of the year.
Not a leap year. 334 days until the end of the year.
Born at the year of 🐴 Horse according to Chinese Zodiac calendar, and under ♒ Aquarius sign according to Western Zodiac calendar.
Saturday, January 31, 2026 as Unix timestamp: 1769853741
5 months in other units of measurement is
- 13,219,200 seconds
- 220,320 minutes
- 3,672 hours
- 153 days
- 21 weeks
How to add 5 months to a date in excel or Google Sheets?
To add or subtract months to a date use EDATE()
formula:
=EDATE(TODAY(), +5)
Replace TODAY() with a cell reference (for example: A1) to manipulate dates other than today's date.
If you want learn more about using Excel or Google Sheets formulas to add or subtract days, weeks, months or years from a date click here. You can also download a free Microsoft Excel sample spreadsheet with examples.