Calculate Working Days from Date in Excel

Microsoft Excel has wonderful function called Workday(). While performing some calculations in Excel workbook, it is quite often to know about how many number of days between two dates. Excel makes this as easy, you just need to subtract the earlier date from the latter date to get total # of days. But in a business environment (any organization), you may not want to know just the number of days between two dates rather wants to know the number of business days(working days) between two dates. We will see about this with some examples as shown below.

Syntax:

=WORKDAY(start_date, days, [holidays])

Method 1:

The below example will explain you working days calculation without holidays mentioned. Holiday can be optional in that formula.

Method 2:

The below example will explain you with holiday option in the formula. Benefit of this function is to exclude the weekends and holidays.

Using this formula you can provide huge number of back dated value to get correct date either with holidays or without holidays.
Thanks for visiting... Hope this post will help you something to understand.