Excluding weekends and holidays from the result of formula =IF(BC456="OPEN",TODAY()-Z456,AU456-Z456)

[anniemercado18]

Hi all. seeking for your help. I am using =IF(BC456="OPEN",TODAY()-Z456,AU456-Z456) to get the number of days a case is open to date. However the result is in calendar days. Is there any way to exclude the weekends and holidays from the result of the said formula?

Thanks
Annie

 

[FormR]

You could try this:

=IF(BC456="OPEN",NETWORKDAYS(Z456,TODAY(),holidays),AU456-Z456)

Substitute holidays for a range of cells that list your holiday dates or create a named range called holidays that lists your holiday dates.

 

[anniemercado18]

Hi Thank you so much for your kind and prompt assistance. it really do helped me alot