SOLVED

Workday.intl - wrong end date

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3172265%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EWorkday.intl%20-%20wrong%20end%20date%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3172265%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi.%26nbsp%3B%3CSPAN%3EI%20am%20working%20on%20a%20project%20planning%20in%20order%20to%20create%20a%20Gantt%20chart%20and%20I'm%20using%20workday.intl%20to%20get%20the%20end%20date%20(completion%20date).%20My%20inputs%20are%20-%20starting%20date%20(of%20a%20task)%20and%20the%20duration%20(how%20long%20will%20take%20to%20complete%20the%20task)%20in%20order%20to%20get%20the%20end%20date%20(completion%20date)%20-%20we%20don't%20work%20Saturday%20and%20Sunday%20and%20Bank%20holidays.%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI'm%20using%20workday.intl(start_date%2Cdays%2Cweekend%20(chose%201-as%20Saturday%20and%20Sunday%20are%20weekend%20days%2Cholidays)-1%20and%20receive%20as%20a%20result%20Sunday%20instead%20of%20Friday.%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20example%2C%20the%20start%20date%20of%20a%20task%20is%20Thursday%20and%20takes%202%20days%20to%20complete%20the%20task%2C%20instead%20of%20getting%20Friday%20as%20a%20result%2C%20I%20get%20Sunday%3F%20I%20have%20checked%20and%20Sunday%20seems%20to%20be%20the%20first%20day%20of%20the%20week%2C%20can%20I%20change%20this%20to%20Monday%20and%20to%20get%20the%20correct%20end%20dates%20for%20my%20workday.intl%20function%3F%20Thank%20you%20in%20advance.%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3172265%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

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 (how long will take to complete the task) in order to get the end date (completion date) - we don't work Saturday and Sunday and Bank holidays.

I'm using workday.intl(start_date,days,weekend (chose 1-as Saturday and Sunday are weekend days,holidays)-1 and receive as a result Sunday instead of Friday. 

For example, the start date of a task is Thursday and takes 2 days to complete the task, instead of getting Friday as a result, I get Sunday? I have checked and Sunday seems to be the first day of the week, can I change this to Monday and to get the correct end dates for my workday.intl function? Thank you in advance. 

3 Replies
best response confirmed by Eliza_Roman (New Contributor)
Solution

@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.

Riny_van_Eekelen_0-1645006053971.png

 

 

 

Thank you @Riny_van_Eekelen
Sorted now. You are my hero!

@Eliza_Roman Glad I could help