Workday

[Sadik]

Hi All,

I am trying to use the Workday function to find the
working date after 9 working days in the UK.

The holidays are (except normal Saturdays and Sundays)is
June 1 and none in July.

The function gives me 14/6/04 where I think it should be
15/6/04 (the date after 9 working days). For July it gives
me 14/7/04 which is correct.

Can you see why it does this in June 04?

Thanks for your help.

Regards

Sadik

 

[Frank Kabel]

Hi
could you post your exact formula (including the data in
your holiday range)

 

[Guest]

Hi Frank,

Thanks for your reply. The formula I am using is:

=WORKDAY(K$2,$F9,1/6/04)

The format and dates are for the U.K. which means Saturday
and Sunday are non working days.

Thanks for your help.

Regards

Sadik

 

[Ron Rosenfeld]

Hi All,

I am trying to use the Workday function to find the
working date after 9 working days in the UK.

The holidays are (except normal Saturdays and Sundays)is
June 1 and none in July.

The function gives me 14/6/04 where I think it should be
15/6/04 (the date after 9 working days). For July it gives
me 14/7/04 which is correct.

Can you see why it does this in June 04?

Thanks for your help.

Regards

Sadik

Workday does not count the first day. So 1 June + 1 --> 2 June.
31 May + 1 also ---> 2 June (since 1 June is a
holiday).


--ron

 

[Sadik]

Thanks Ron. This explains the probelm I am having with the
dates.

Regards

Sadik