Forum Discussion

Copper Contributor

Apr 13, 2018

Help with Workday formula

Hi, I am having issue with the workday formula calculating 1 Jan 2018 (which is also bank holiday) to show next working day. For example: A1: 01/01/2018 A2: 01/01/2018 (holiday) A3: =WORKDAY...

Excel Formula

Formulas & Functions

Grace S

Copper Contributor

Apr 13, 2018

Hi Haytham,

Thanks for the explanation.

Can you recommend the formula so that for 1st Jan is accounted for holiday as it is the start date? So Excel can find that 2 Jan is the actual start date (acknowledging the start date is holiday) and the so than it can then find that the next working day so the result showing as 3 Jan?

Grace

Haytham Amairah

Silver Contributor

Apr 13, 2018

Hi,

I suggest using this formula instead:

=WORKDAY(IF(A1=A2,A1+1,A1),1,A2)

This portion of the formula IF(A1=A2,A1+1,A1) will check if the start date is equal to the holiday.

If so, it will add one day to the start day, otherwise, will still as it is.

Grace S
Copper Contributor
Apr 13, 2018
Thank you, much appreciated.

Grace