Date calcualtion using on workdays

  • 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)))

  • Re: Date calcualtion using on workdays


    I have it now so it is calculating working days using the formula below, but I need to figure out how to account for holidays. Thanks for the help.



    =IF(AA589="Void","Void",IF(AB589="closed",NETWORKDAYS(I589,AA589),NETWORKDAYS(I589,(TODAY()))))

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!