Auto Fill Weekdays Only
Hi
use WORKDAY for this. e.g.
=WORKDAY(A1,10)
Note: the Analysis Toolpak Addin has to be installed for
this
-----Original Message-----
Hey,
I'm new with excess and trying to use it to estimate the
days between stages at a construction site. For example,
Starting Date of Excavation is 6/2/04...I need it to
calculate 10 days from that date and not land on a
weekend. If 10 days did land on a weekend then it would
just get bumped to the monday. Please help if you can.
Thank you.
.
|