View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rotata Rotata is offline
external usenet poster
 
Posts: 8
Default 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



--