ddr summary/file/custom functions

Custom Function: GetWorkDays in Tasks.fmp12

Show Dependency
GetWorkDays
#idnamevisiblenumber of paramsparameter namesfunction code
11GetWorkDaysTrue2StartDate;DueDate
Int 	( ( DueDate - StartDate ) / 7 ) * 5 

+ 

Case 	( 
		DayOfWeek ( DueDate ) < DayOfWeek ( StartDate ) ; 
		Min ( 5 ; DayOfWeek ( DueDate ) - 1 ) + Max ( 0 ; 6 - DayOfWeek ( StartDate ) ) ;

		DayOfWeek ( StartDate ) < 7 ; 
		Min ( 6 ; DayOfWeek ( DueDate ) ) - DayOfWeek ( StartDate ) ; 

		0 
		)