View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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.
.