Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workdays not working as expected
Help!
(running Office 2003 on XP) I am trying to calculate 11 workdays from a given date. Some holidays we work, some we don't. We shut down for up to two weeks at Christmas. I put in the workday formula as I think it to be. The result isn't what I expected. Lets say I put the date to start in cell A1, for example 1/5/09 In cell B1 I insert the following =workday(a1,11,0) The result displayed 1/20/09 so, I stuck in an extra holiday or two =workday(a1,11,1) displays 1/20/09. =workday(a1,11,2) displays 1/20/09. =workday(a1,11,10) displays 1/20/09. =workday(a1,11) displays 1/20/09. Where am I going wrong? Changing the -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code not working as expected. | Excel Discussion (Misc queries) | |||
Help !!! My code is not working as expected. | Excel Discussion (Misc queries) | |||
Iserror not working as expected | Excel Worksheet Functions | |||
=NETWORKDAYS not working as expected and as it once did | Excel Worksheet Functions | |||
Lookup Not working as expected | New Users to Excel |