The NETWORKDAYS function in Google Sheets allows you to calculate the number of working days between two dates. Working days are typically defined as weekdays (Monday through Friday) and exclude weekends (Saturday and Sunday) and holidays.
Here’s how to use the NETWORKDAYS function:
- In the cell where you want to display the result of the NETWORKDAYS function, enter the formula: =NETWORKDAYS(start_date, end_date, [holidays])
- Replace “start_date” with the start date of the period you want to calculate.
- Replace “end_date” with the end date of the period you want to calculate.
- Replace “[holidays]” with a range of cells that contain a list of dates that should be excluded from the calculation. If you do not want to exclude any holidays, you can leave this argument blank.
Here’s an example of how to use the NETWORKDAYS function:
=NETWORKDAYS(A1, A2, A3:A10)
This formula calculates the number of working days between the dates in cells A1 and A2, excluding the dates in the range A3:A10.
I hope this helps! Let me know if you have any questions.