Hi all

I am trying to create a spreadsheet which calculates how many days overdue a folder has been submitted, and also tells the administrator which day the folder should be chased. This needs to exclude weekends, however, the spreadsheet includes multiple columns which should interact with each other as attached

As this spreadsheet is used daily by someone with a busy work schedule I would ideally like to only need to input the due date and return date for ease

Both the chase day and days overdue need to exclude weekends

The days overdue already contains a formula which is the Return date minus the Chase day

The Chase day is always the due date + 7 minus weekends

So I want the spreadsheet to have formulas in each column with these functionalities:

Due date: manually entered date by the admin
Chase day: Due date + 7 minus weekends
Return date: manually entered by the admin
Days overdue: Return date - chase day minus weekends

I also need to include an IF function so that if one of the sections is left blank (as sometime happens) the formulas do not return any result (so IF(G7>0)) WITHOUT using conditional formats because the spreadsheet also contains dropdowns, and if someone uses the dropdown I don't want it to corrupt the conditional formatting which can sometimes happen (unless someone knows a fix for this?)

I have tried a few ways of doing this already but I always find that one part will succeed and the other will fail

Thank you in advance for the help!

Dates spreadsheet.png