What date is 6 months from today?
Find out which date will be 6 months from now. When is today plus 6 months. The calculator adds or subtracts days, weeks, months and years from now.
Today is July 21, 2025.
6 months from today will be:
Wednesday, January 21, 2026
21th day of of winter, 21th day of the year.
Not a leap year. 344 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.
Wednesday, January 21, 2026 as Unix timestamp: 1768975777
6 months in other units of measurement is
- 15,897,600 seconds
- 264,960 minutes
- 4,416 hours
- 184 days
- 26 weeks
How to add 6 months to a date in excel or Google Sheets?
To add or subtract months to a date use EDATE()
formula:
=EDATE(TODAY(), +6)
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.