Forum Discussion
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...
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.
Thank you, much appreciated.
Grace
Grace