Text Mode calculation that will tell me the number of days between entry date and Actual Completion Date BUT excludes holidays. | Community
Skip to main content
D
DawnmarieD
Level 5
June 28, 2021
Question

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

  • June 28, 2021
  • 2 replies
  • 698 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

R
Community Advisor
Richard_Le_Community Advisor
Community Advisor
June 28, 2021

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.

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    June 28, 2021

    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")

      Terms & ConditionsAccessibility statement

      Loading footer...