Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
calculate next calendar friday
Hello, I am trying to come up with a formula that will calculate the next calendar friday after a minimum 10 working days from my processing date.
I've had help from Craig to get this formula.
How can I modify this formula to accommodate the minimum 10 working days before returning the next Friday?
=IF(WEEKDAY(Orderby6) < 7, Orderby6 + (6 - WEEKDAY(Orderby6)), Orderby6 + 6)