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

Which Date Is

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.

What date is 6 months from today? — Dates Calculator
What date is 6 months from today? — Dates Calculator

People also search

Alex Fedorov
Created by Alex Fedorov
Last updated : July 26, 2024