What if the dates are greater than one week apart? i.e an invoice was approved on Jan 6 and processed on Jan 18. In this scenario, I would like to subtract 4 from the total. Is there a condition that could be added to the formula to account for this? Possibly: IF(WEEKDAY(Q45+7)<=WEEKDAY(K45),Q45-K45-4 Again, I would like this included in the original formula so that the formula is constant throughout the spreadsheet.