NETWORKDAYS / WORKDAY - It shouldn’t be much of a work
Calculating number of working days between two dates can be cumbersome as non working days include weekends and holidays and both tend to change with different jurisdictions.
To make this task easy Excel has NETWORKDAYS function. One just has to mention the start and ending dates with the option mentioning holidays as a range of cells. Even better formula is NETWORKDAYS.INTL which let you choose which day of the week is weekend.
For more on this read this detailed tutorial: Calculate number of Work Days in Excel using formula
WORKDAY function on the other hand determines the working day from a certain date after considering specific number of working days. This helps managers in many ways. For example determining due date of certain invoice.
WORKDAY.INTL adds more to flexibility and let you choose which day(s) of the week is(are) weekend(s).
Here is one situation:
Mr. A sent invoice of 10,000 to Mr. B payable in 20 (working) days. Invoice was issued on January 10, 2017. What is the due date of invoice?
By simply adding 20 to said date will render a wrong due date for not excluding weekends:
=”1/10/2017″+20 = 1/30/2017
or better yet use DATE function to enter dates as entering dates as text can be problematic:
=DATE(2017,1,10)+20 = 1/30/2017
WORKDAY function will help us get the correct due date considering the weekends during calculation:
=WORKDAY(“1/10/2017”,20) = 2/7/2017
WORKDAY function considers Saturday and Sunday as the weekends. But not all jurisdictions have the same weekend. Sometimes it is just Sunday or it is Thursday and Friday. For such situations we use WORKDAY.INTL in which we have the option to use weekend combination.
Consider the same example as before with slight change as following:
Mr. A sent invoice of 10,000 to Mr. B payable in 20 (working) days. Invoice was issued on January 10, 2017. What is the due date of invoice? Weekend is Friday only.
For this situation formula will be as following:
=WORKDAY.INTL(DATE(2017,01,10),20,16) = 2/2/2017
