Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a formula that is calculating the number of days between today and the date. I would like to add the word ''days'' after the number, for an example ''20 days'' My actual formula is =today()-[Cration Date](Days)
=Dual(today()-[Cration Date]&' Days',today()-[Cration Date])
Or
=Interval(today()-[Cration Date],'d Days')
=Dual(today()-[Cration Date]&' Days',today()-[Cration Date])
Or
=Interval(today()-[Cration Date],'d Days')
You could format it to a number with format as below.
= num(today()-[Cration Date], '# ##0 days')