View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.