I'm having a hard time figuring out what's triggering a Syntax Error on this Flow Formula (Number).
My goal is to only count weekdays
between the Start and the End dates
- {!debugVar_EndDate} & {!debugVar_StartDate} are both Date variables
IF(
((5 * (FLOOR(({!debugVar_EndDate} - DATE(1900, 1, 8)) / 7 )) + MIN(5, MOD({!debugVar_EndDate} - DATE(1900, 1, 8), 7)))
-
(5 * (FLOOR(({!debugVar_StartDate} - DATE(1900, 1, 8)) / 7 )) + MIN(5, MOD({!debugVar_StartDate} - DATE(1900, 1, 8), 7 )))) + 1,
8
)
1 answer
Try this:
(5 * ( FLOOR( ( {!debugVar_EndDate} - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( {!debugVar_EndDate} - DATE( 1900, 1, 8), 7 ) ) )
-
(5 * ( FLOOR( ( {!debugVar_StartDate} - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( {!debugVar_StartDate} - DATE( 1900, 1, 8), 7 ) ) )
