How it's counted
Business days count Monday to Friday only. Starting tomorrow, the calculator skips each Saturday and Sunday until it has counted 100 working days. Public holidays are not skipped, so add one day for each holiday that falls in between.
In a spreadsheet
In Excel or Google Sheets, type =WORKDAY(TODAY(),100) and format the cell as a date. WORKDAY skips Saturdays and Sundays; add a holiday list as a third value to skip those too. To count from a different start date, use the date calculator.
100 business days after other dates
| Starting from | 100 business days later |
|---|---|
| Tue, Oct 13 (today) | Tuesday, March 2, 2027 |
| Wed, Oct 14 | Wednesday, March 3, 2027 |
| Thu, Oct 15 | Thursday, March 4, 2027 |
| Fri, Oct 16 | Friday, March 5, 2027 |
| Sat, Oct 17 | Friday, March 5, 2027 |
| Sun, Oct 18 | Friday, March 5, 2027 |
| Mon, Oct 19 | Monday, March 8, 2027 |
Business days from today
Frequently asked questions
What day is 100 business days from today?
100 business days from today is Tuesday, March 2, 2027.
What day of the week is 100 business days from today?
It is a Tuesday.
What date is 100 business days from now?
Tuesday, March 2, 2027. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 100 business days?
140 calendar days is 20.0 weeks; 100 business days is about 20.0 working weeks.
What date was 100 business days ago?
Tuesday, May 26, 2026.
Does "100 business days from today" include today?
No. Today is day 0, so the count starts from tomorrow (or yesterday, for dates in the past).
How do I work out 100 business days from today in Excel or Google Sheets?
Type =TODAY()+140 and format the cell as a date.
How many days is 100 business days?
140 calendar days, counting from today.