I have a spreadsheet currently that I am using to calculate the number of days that something was open. I would like to modify the formula to do the calculation using only work days. The formula that I am currently using is listed below. I was thinking that the best function to use if NETWORKDAYS, and then I can have it include holidays as well. Can someone please help me with the use of this function in my formula and where to have it pull holidays from.
Thank you in advance
=IF(AA589="Void","Void",IF(AB589="closed",(AA589-I589),(TODAY()-I589)))