Auto Fill Weekdays Only
 

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.

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.

Auto Fill Weekdays Only
 

Hi Berto88!

No!

=WORKDAY(G12,$B$13)
Format (eg) dd-mmm-yyyy

Where G12 contains the date you want to add the number of days in B13.

If you have a range of dates containing holidays that you name
HolidayRange, you can use:

=WORKDAY(G12,$B$13,HolidayRange)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

"Berto88" wrote in message
...
so if I wanted to get the date for a workday 10 days later it would
be "=WORKDAY(+G12+$B$13)" ?