Calculating a Finish Date Given a Starting Date and the Number of Work Days
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)