Workday.intl - wrong end date

Hi. I am working on a project planning in order to create a Gantt chart and I'm using workday.intl to get the end date (completion date). My inputs are - starting date (of a task) and the duration (h...

excel

Riny_van_Eekelen
Feb 16, 2022
Eliza_Roman That's due to the -1 at the end. Without it the formula will return the following Monday, which is the 2nd working day after Thursday. Friday being the 1st, Monday the 2nd. Deducting 1 outside the brackets turns it into Sunday as the connection with working days is lost. You obviously want to count the Thursday as the first day. Then you need to rewrite the formula by deducting 1 from the number of days. Note the C2-1 in the picture below.

Forum Discussion

Workday.intl - wrong end date

Resources