Here is my excel formula I use to find a FRIDAY shipping date.
=WORKDAY($T1165,-10)-1+(WEEKDAY(WORKDAY($T1165,-10)-1)>=6)*7-WEEKDAY(WORKDAY($T1165,-10)-1)+6
I changed to this in Smartsheet but doesn't work. Any advice?
=workday([start date]12,-10)-1+(weekday(workday([start date]12,-10)-1)>=6)*7-weekday(workday([start date]12,-10)-1)+6