Forum Discussion
Help with Workday formula
Hi,
The result of the formula is correct!
Please note that the https://support.office.com/en-us/article/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33?NS=EXCEL&Version=16&SysLcid=1033&UiLcid=1033&AppVer=ZXL160&HelpId=xlmain11.chm60519&ui=en-US&rs=en-US&ad=US function works this way:
- It looks at the start date.
- It skips the to the next workday that is nonweekend and nonholiday.
- The number of skips is based on the second argument of the function (days).
- You have an option to define the holidays in the third argument, to make the function take them into account.
- The holidays' argument is optional, you can omit it, which is means that there are no holidays.
- No matter if the start date is a holiday or weekend, it's just a starting point.
In the formula above, since the start date is 01/01/2018 and the number of days (skips) is 1, it will return the next workday 02/01/2018 which is nonweekend and nonholiday.
The formula will return 03/01/2018 in case if you make the day of 02/01/2018 is the holiday.
Hope that helps
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
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