Thread: Excl 97
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default Excl 97

David,

Use the WORKDAY function that is in the analysis toolpak.

=WORKDAY(start_Date, days, [holidays])

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"David Bakun" wrote in message
...
I have excel 97 installed at my work station. I set up a
worksheet with a start date it then adds the number of
days for the discipline in the 3rd column. My prblem is
how do I set the 3rd column for "net workdays".

Any one who can help me I thank profusely.


David