none
Wrong Result in workday function RRS feed

  • 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