Text Mode calculation that will tell me the number of days between entry date and Actual Completion Date BUT excludes holidays.

[dawnmaried10]

I have the text mode for the number of days between the entry date to the actual completion date. After I looked I could see the average was between 1 and 5 days but there were a few that were up to 19 days. The ones outside the average are calculating days during winter break or holidays that should not be included. Can I excluded those days as they are excluded on our calendar?

[Richard_Le_]

Hi Dawnmarie,

The way to exclude non-working time in your calculation is to use the 'WORKMINUTESDIFF' expression, which will look at the working minutes between two dates as defined by your work schedules. As long as public holidays are declared in your work schedules, these will be excluded from the calculation because there are no 'working minutes' during a public holiday.

For example:

ROUND(WORKMINUTESDIFF(Entry Date,Actual Completion Date)/480,2)

The above code will calculate the working minutes between the entry date and actual completion date and divide the value by 480 (assuming 8 hours in a working day (8 x 60 = 480)) which will give you the number of days. Then we have rounded the value to 2 decimal places.

Hope that helps!

Best Regards,

Rich.

[AnthonyIm]

I know for a calculated field on a custom form, you can use...

WEEKDAYDIFF(Entry Date,Actual Completion Date,"521504260091b36b47f167f8571ae01c")

The ID number is the Workfront ID of the Schedule whose holidays you don't want counted.

However, I have never tried this in a report as a column so not sure if this will work...

WEEKDAYDIFF({entryDate},{actualCompletionDate},"521504260091b36b47f167f8571ae01c")