Wednesday, 23 September 2015

Excel Tips - Tip 32 (Using net working days Formulae)


Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If ever we want to calculate the number of working days between two dates. Then we can do the same by using command “NETWORKDAYS”

What Does It Do ?

·         This function will calculate the number of working days between two dates.
·         It will exclude weekends and any holidays.
·         Holidays : This is a list of dates which will be excluded from the calculation, such as Festivals and bank holidays

How to use it ?

'=NETWORKDAYS(StartDate,EndDate,Holidays)

For example, please check the images.




Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.


If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:


If you have something that you want to share with the group, please write to excelms.tips@gmail.com


Thanks & Regards,

CA Mohit Bansal
Excel Enthusiast


+91-9045773456

No comments:

Post a Comment