Use the NETWORKDAYS or NETWORKDAYS.INTL functions to count the number of workdays between two dates. Learn from examples, including subtracting holidays and customizing which days are your weekends.
Read more about these two functions:
https://sheetshelp.com/networkdays/
https://sheetshelp.com/networkdaysintl/
0:00 - Two dates and other basics
1:30 - Holidays
3:30 - #VALUE! error
4:09 - Weekends
To count only the cells that contain dates between two days, try using the COUNTIFS formula: https://sheetshelp.com/count-cells-be...
#googlesheets #spreadsheets #networkdays