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

SergeiBaklan

Diamond Contributor

Apr 13, 2018

Hi Grace,

That's correct result - after Mon, 01 Jan the next working day is Tue, 02 Jan since it's not day-off (not public holiday and not weekend).

Grace S

Copper Contributor

Apr 13, 2018

Hi Sergei,

Thanks for the quick response. But in the formula stated that 1st Jan is a holiday hence I expect that the first working day is on the 2nd, and the next working day is the 3rd?

Grace