
Video How to calculate working days using excel with sample
Definition of Working Days:
It is the period of time between two dates after deduction the week ends and the holidays, in other meaning the net effective days to work.
calculate working days
Usually we need to calculated Working Days Between 2 Dates, However to Count Work Days Excel you need to identify the week ends and the holidays. Microsoft excel can do this for us in very simple way using the built in formulas in excel. To calculate them in excel simply use the formula NETWORKDAYS.INTL, then select the start date, end date, week end and holidays and

excel will calculate how many days between the start date and end date and deduct the week ends and holidays. very simple 🙂
Check the following video to see how you can do it in excel
See the video:
Down oad The Sample File