AnsweredAssumed Answered

Calculating a Finish Date Given a Starting Date and the Number of Work Days

Question asked by StuartDuggan on Jan 9, 2015
Latest reply on Jan 10, 2015 by philmodjunk

Title

Calculating a Finish Date Given a Starting Date and the Number of Work Days

Post

Hi, Can someone please help?

I am trying to determine an 'EndDate' that is 10 weekdays after a 'StartDate'. In addition to Saturdays and Sundays, I want to exclude known weekday holidays, which i have included in lookup tables. I have proved that the 'LookUp_High' and 'LookUp_Low' values are correct, however the calc is still not returning the correct date and provides weekend dates?

The following is where i'm up to at present:

StartDate + Int ( 10 / 5 ) * 7 + Middle ( "12345012340123601256014560345623456" ; ( DayOfWeek (StartDate) - 1 ) * 5 +  Mod (10 ; 5 ) + 1 ; 1 )- (Lookup_High - Lookup_Low)

 

In anticipation

Stuart

Outcomes