Hi,

You could try this. I am sure there is a better way to solve this problem.

=IF(TEXT(G5+G6,"dddd")="Sunday",G5+G6+1,IF(TEXT(G5 +G6,"dddd")="Saturday",G5+G6-1,G5+G6))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Morocco Mole" wrote in message
...
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