How to count the days until a date
Here it is with your numbers:
- Count the days from November 9, 2026 up to July 4, 2027: 237.
- Split it into weeks: 237 ÷ 7 gives 33 weeks and 6 days.
- Take out the weekends: 67 days fall on a Saturday or Sunday, which leaves 170 weekdays.
It means 237 days (33 weeks, 6 days) are left until July 4, 2027, a Sunday, and 170 of them are weekdays.
Today doesn’t count as a day left: tomorrow is 1 day away. Days are calendar days, so a change to or from daylight saving time never adds or loses one. If the date has passed, you see how many days ago it was.
Source Microsoft Support · Calculate the difference between two dates ↗
Days until your date in other units
| Unit | Until your date |
|---|---|
| Days | 237 |
| Weeks and days | 33 weeks, 6 days |
| Years, months and days | 7 months and 25 days |
| Weekdays (Mon–Fri) | 170 |
| Weekend days | 67 |
| Day of the week | Sunday |
Weekdays are Monday to Friday, counting today but not the day itself. Public holidays are not taken out.
Source Microsoft Support · NETWORKDAYS function ↗
Days until holidays
For the big days, our countdowns already know the date, even when it moves each year like Thanksgiving and Easter:
- Days Until St. Patrick's Day
- Days Until Mother's Day
- Days Until Father's Day
- Days Until the Fourth of July
- Days Until Christmas
- Days Until Halloween
- Days Until Thanksgiving
- Days Until Easter
- Days Until New Year's Day
- Days Until Valentine's Day
- Days Until Summer
- Days Until Your Birthday
FAQs
How do I calculate days from dates in Excel?
Put the earlier date in A1 and the later one in B1, then use =DATEDIF(A1,B1,"d"). It gives the number of full days between them, the same count as this page.
Source Microsoft Support · Calculate the difference between two dates ↗
How to calculate days until a birthday?
Enter the month and day of the birthday and leave the year empty. The page counts to the next one, and says “Today” on the day itself. From November 6, 2026, a June 15 birthday is 221 days away.
How many weeks are left until the 31st?
Count the days, then divide by 7. From November 6 to December 31, 2026 is 55 days, which is 7 weeks and 6 days.
Sources
- Microsoft Support: Calculate the difference between two dates
- Microsoft Support: NETWORKDAYS function