One way...

Enter the first date in your first cell. Assume this is cell A1.

Enter this formula in cell A2 and copy down as needed:

=A1+CHOOSE(WEEKDAY(A1),1,1,1,1,1,3,2)

--
Biff
Microsoft Excel MVP


"martin" wrote in message
...
I am putting together a project plan in Excel. The task dates are driven
by
the selected due date. I would like to enter the due date and have the
remaining dates populate based on pre-determined values. However, is it
possible to prevent these values from falling on a weekend (e.g. round to
the
nearest workday?)