How to Calculate Hours in Excel Excluding Weekends. ... Click on cell A1 and enter the earliest date and time from where you want to count. Enter the date first, ...

As you can see in the screenshot above, 2017 contains 252 total business days, excluding weekends and federal holidays. In case you are wondering why the total business days declined by only eight ...