Column that automatically counts days/age of item?

Platform discussions Special workflows & use cases
,
1

Hi There,

When I add a new item to a board I have the creation log visible, however, I would also like a column that automatically counts how many days that item has existed. Ideally, I’d like a formula to do this.

I thought this would work, but it doesn’t seem to be:

image
image762×434 29.6 KB

Any help would be smashing, thanks!

Leon

2

@leon.cliff

Are you wanting to return calendar days or business days?

3

Jim! I somehow knew you’d be my savoir again! Business days would be ideal, please?

4

@leon.cliff

Here you go… Be warned, the NETWORKDAYS() function is a little squirrely. Probably why it’s not in monday’s documentation. But it will get you close:

WORKDAYS(FORMAT_DATE(TODAY()),FORMAT_DATE({Creation Log}))

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Favorite Movies”)

1 Like
5

Thanks again, Jim!! As always, perfect solution.

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.