I have a column that I call 'Agenda Due Date'. I have been using the following formula to calculate the agenda due date which is 1 working day before the 'review meeting date' which I have as a separate column that is entered manually. If the 'Review Date' is blank then I want the 'Agenda Due Date' to be blank.
My problem is if the Review date is on a Monday, the Agenda Due Date is the Sunday. I want the due date be the Friday before. How do I change the formula to only consider working days?
=IF([Review Date]="","",[Review Date]-1)