Auto Fill Weekdays Only
As Frank pointed out, the function is WORKDAY rather than WORKDAYS.
See Excel help for details.
--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
Look at the Workdays function (it is in the analysis toolpak, so you
would
need to have that installed).
--
Regards,
Tom Ogilvy
"Berto88" wrote in 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.
|