ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excl 97 (https://www.excelbanter.com/excel-programming/271581-excl-97-a.html)

David Bakun

Excl 97
 
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

Bob Phillips[_5_]

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





All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com