Count days between 2 dates

Platform discussions
1

Hi everyone.
I’m looking for a formula to make the following difference: today’s date minus the item’s creation date.
I would like the result in days.

For example, if the item was created on 1/1/2021 and today is 1/7/2021 I would like the result “6”.

Thanks!

2

Hi @AleRun - Absolutely! Here’s a short video clip to show you how: Screen Recording 2021-01-07... Let me know if you have any questions.

2 Likes
3

Works! :sunglasses:
Thanks for your help.
I searched several times among the functions of the Formula field … but I really ran away !!! :sweat_smile: :sweat_smile: :sweat_smile:

1 Like
4

This formula works DAYS({Date records returned},{Date records uploaded})

For work days (remove weekend) I did this: WORKDAYS({Date records returned},{Date records uploaded})-1