=A1+SUM((WEEKDAY(A1,2)={6,7})*{-1,1})


"Morocco Mole" wrote:

Hello.

I have some tasks that where the duration is in days (not workdays).

What formula would I used to calcuate a future date and if it lands on a
weekend to "round up" the future date to the following Monday (or round down
the Friday)

I know of the workday function but I believe the day input is the number of
workdays needed (where I have total days needed).

--
Thanks,

Morocco Mole