Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Cue the extraordinary. Show-stopping experiences that raise the digital bar. Apply now for the 2023 Adobe Experience Maker Awards.

Text mode, how to count if Planned completion date is same or more than 3 three days than task Entry date?


Level 1

Hi, Does anyone have an idea how to compare planned completion date and entry date. I was asked to count this value and then if the planned completion is more than than 3 days from the entry date, add text on the column.


Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies


Community Advisor

Hi Mari,

Using the following text mode in a column on your view will count the number of weekdays between the task entry date and planned completion date:

displayname=Days between entry and PC




The following text mode will return the text '3 or more days' if the difference between entry and planned completion is greater than or equal to 3, else it will return 'Less than 3 days'

displayname=3 days or more?


valueexpression=IF(WEEKDAYDIFF({entryDate},{plannedCompletionDate})>=3,'3 or more days','Less than 3 days')


Hope that helps!

Best Regards,



Level 1

Hi Richard!

Thank you so much, that works just perfect.

I actually use this to Ad-hoc calculation where we see if work order is so called fast order or not.

Thanks one more time and have a nice summer!

Best Regards,

Mari Perasto

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now