Excel Tricks and Tips

Need to know how many more work days until the next TOR?  Click on the link for 14 other Excel tips and tricks.

Find total working days between any two dates, including holidays

11-find-total-working-days-between-2-dates

If you work on project plans, gantt charts alot, this can be totally handy. Just type =networkdays(start date, end date, list of holidays) to fetch the number of working days. In the above sample you can see the number of working days between New years day and September first of this year (labor day).

————-

I’ve been on a diet for two weeks and all I’ve lost is two weeks.
Totie Fields
Share

Leave a Reply