Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
frequency excl #N/A | Excel Worksheet Functions | |||
Use excl (2002) in presentation | Excel Discussion (Misc queries) | |||
How can I always ROUND UP to the nearest multipal of 5 in excl | Excel Worksheet Functions | |||
will Excl run on windows xp home edition? | Excel Discussion (Misc queries) | |||
Subtotal excl errors | Excel Worksheet Functions |