ExcelBanter - how do I calculate the time service minus holidays?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I calculate the time service minus holidays? (https://www.excelbanter.com/excel-worksheet-functions/89909-how-do-i-calculate-time-service-minus-holidays.html)

grbear

how do I calculate the time service minus holidays?

I am needing to calculate the number of working days it takes to complete a
response - which needs to caluclate to not add holidays and weekends end. I
am not sure how to do this?

Barb Reinhardt

how do I calculate the time service minus holidays?

Try using NETWORKDAYS()

"grbear" wrote:

I am needing to calculate the number of working days it takes to complete a
response - which needs to caluclate to not add holidays and weekends end. I
am not sure how to do this?

All times are GMT +1. The time now is 08:33 AM.