# Wrong Result in workday function

• ### Question

• Sir,

WORKDAY formula Giving wrong Result.

Month:  May 2019

Total Days: 31

Saturday & Sunday =8

Working Day =23

=WORKDAY(01/05/2019, 23, "No Holiday)

Giving Result = 03/06/2019 (Its Wrong)

Result Should be 01/06/2019

Give me solution

My Other email is p.rajnikant@gmail.com

Thursday, December 13, 2018 12:03 PM

### All replies

• No, it's correct, since the 1st and 2nd of June are Saturday and Sunday. So the first working day in June of 2019 is the 3rd of June.

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Thursday, December 13, 2018 12:23 PM
• Hi,

The formula is OK please see the attached table:

 Date WeekDay Count Count Cum. 01/05/2019 4 0 0 02/05/2019 5 1 1 03/05/2019 6 1 2 04/05/2019 7 0 2 05/05/2019 1 0 2 06/05/2019 2 1 3 07/05/2019 3 1 4 08/05/2019 4 1 5 09/05/2019 5 1 6 10/05/2019 6 1 7 11/05/2019 7 0 7 12/05/2019 1 0 7 13/05/2019 2 1 8 14/05/2019 3 1 9 15/05/2019 4 1 10 16/05/2019 5 1 11 17/05/2019 6 1 12 18/05/2019 7 0 12 19/05/2019 1 0 12 20/05/2019 2 1 13 21/05/2019 3 1 14 22/05/2019 4 1 15 23/05/2019 5 1 16 24/05/2019 6 1 17 25/05/2019 7 0 17 26/05/2019 1 0 17 27/05/2019 2 1 18 28/05/2019 3 1 19 29/05/2019 4 1 20 30/05/2019 5 1 21 31/05/2019 6 1 22 01/06/2019 7 0 22 02/06/2019 1 0 22 03/06/2019 2 1 23

Guy Zommer

Thursday, December 13, 2018 12:27 PM