Aug 13 2019 06:08 PM
Hi All -
I am trying to fumble my way through a project timeline in excel. See screenshot below. I'm using a start date, plus a duration to create a schedule template. How do I get it to recognize weekends/holidays? The threads I found in search seemed to be about counting days in a specific range. Thank you in advance for the help.
Aug 14 2019 12:18 AM
You can use WORKDAY() to calculate dates and NETWORKDAYS() to calculate duration.
you can also exclude your holidays too along with weekends.