Counting Covid Days

[shaftdx]

I work for a school bus company I want to be able to count out just the days we have been bringing the kids to and from school. Not counting weekends and if the school closes for a day or 2 because of a covid scare I want to factor that in too. Any ideas? I would need to add in a start date for several different districts

 

[Joe4]

You can create a list of the Holidays and other days you don't bring kids to school (i.e. Covid days), and then use the Networkdays function, as shown here:

MS Excel: How to use the NETWORKDAYS Function (WS)

This Excel tutorial explains how to use the Excel NETWORKDAYS function with syntax and examples. The Microsoft Excel NETWORKDAYS function returns the number of work days between 2 dates, excluding weekends and holidays.

www.techonthenet.com

 

[shaftdx]

You can create a list of the Holidays and other days you don't bring kids to school (i.e. Covid days), and then use the Networkdays function, as shown here:

MS Excel: How to use the NETWORKDAYS Function (WS)

This Excel tutorial explains how to use the Excel NETWORKDAYS function with syntax and examples. The Microsoft Excel NETWORKDAYS function returns the number of work days between 2 dates, excluding weekends and holidays.

www.techonthenet.com

I definitely think I can make this work! Thank you!

 

[Joe4]

You are welcome.