Workday

  • Thread starter Thread starter Sadik
  • Start date Start date
S

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
 
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
 
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
Click to expand...

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