Is there a way to calculate the number of weekdays/business days between two dates? I have spent some time searching the internet and the Alteryx Community, but cannot find any solutions to this.
Thanks!
Jessica
Hi jdunkerley79,
Would you please explain this part:
1 +
((DateTimeDiff([EndDate],[StartDate],"days")*5 - ([StartWeekday]-[EndWeekday])*2) / 7) +
IIF([EndWeekday]==6,-1,0) +
IIF([StartWeekday]==0,-1,0)
Regards,
MJ