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