I need to be able to calculate the number of working days between two dates determined in “Start Date” and “End Date” columns. I know the DATETIME_DIFF formula exists, but it includes weekends and public holidays – I need only working days to be calculated.
Is this something that can be achieved with a Script block?
Best answer by Kamille_Parks11
Well if you don’t want to use DATETIME_DIFF(...) why not just use WORKDAY_DIFF(startDate, endDate, [holidays]).
WORKDAY_DIFF() doesn’t include weekends and you can specify which holidays to exclude.
+27Well if you don’t want to use DATETIME_DIFF(...) why not just use WORKDAY_DIFF(startDate, endDate, [holidays]).
WORKDAY_DIFF() doesn’t include weekends and you can specify which holidays to exclude.
Well if you don’t want to use DATETIME_DIFF(...) why not just use WORKDAY_DIFF(startDate, endDate, [holidays]).
WORKDAY_DIFF() doesn’t include weekends and you can specify which holidays to exclude.
Thanks very much! I didn’t realize this function existed, haha :grinning_face_with_sweat:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.