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

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


Level 10

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