Round returned date to working day?
I've been using a formula to calculate due dates, which are always 90 calendar days from the original date column. This is the formula: =IF([Resubmission Required?]@row = "true", [Date Decided (Approved/Rejected)]@row + 90, "n/a")
However, because we are required to calculate these dates in calendar days, many of the dates returned fall on a Saturday or Sunday. Is it possible to write a formula that not only calculates the "technical" due date (+90 calendar days) but will also round the date BACK to the last workday (Friday) if the returned date falls on a weekend? Happy to provide more details if needed.
Help Article Resources
Check out the Formula Handbook template!