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