Counting Days Between Two Dates With Weekends, Without Holidays

cthrasher97141

I am looking for a way to get a count of days between a start date and end date, but I want to include weekends and exclude holidays. Is there a function or combo of functions I could use?

Paul Newcome

I would suggest creating a list of all holiday dates in a separate sheet and then referencing that like so:

=[End Date]@row - [Start Date]@row - COUNTIFS({Holiday Sheet Date Column}, AND(@cell >= [Start Date]@row, @cell <= [End Date]@row))

SoS | Dan Palenchar

Hello @cthrasher97141,

Just use NETWORKDAY or NETWORKDAYS and make sure your project settings have no holidays included.

Paul Newcome

Do you mean you want to include weekends in the count and exclude holidays from the count?

cthrasher97141

Hi Paul!

Yes you are correct.

Paul Newcome

I would suggest creating a list of all holiday dates in a separate sheet and then referencing that like so:

=[End Date]@row - [Start Date]@row - COUNTIFS({Holiday Sheet Date Column}, AND(@cell >= [Start Date]@row, @cell <= [End Date]@row))

cthrasher97141

Thank you so much Paul!

Paul Newcome

Happy to help. 👍️