We consider saturdy, and sunday is holiday..

so when I add +10 with current date, It should show me the date excluding Saturday, sunday,

for example If I input as (5/25/2016)+ 10 then result should be 6/8/2016

Is it make sense ?

We consider saturdy, and sunday is holiday..

so when I add +10 with current date, It should show me the date excluding Saturday, sunday,

for example If I input as (5/25/2016)+ 10 then result should be 6/8/2016

Is it make sense ?

- 1 person found this helpful
A couple of alternatives that calculate it as 8th June 2016

Let ( [

startDate = getasdate( "25/5/2016" ) ;

days = 10 ;

day = If ( DayOfWeek ( startDate ) = 1 ; 7 ; DayOfWeek ( startDate ) - 1 )

];

startDate + days + If ( day = 6 ; 2 ; 0 ) +

( Floor ( ( days -1 + ( If ( day = 6 ; 1 ; Mod ( day ; 6 )^1 ) ) ) /5 ) *2 )

)

Or

Let ([ StartDate = GetAsDate("25/05/2016") ;

WorkDays = 10 ]

;

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

)

Will something like this help:

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