Formula for Start Date to Today...in Years & Months

1

I have a Start Date Column with a date populated. I want a Tenure column that calculates "todays date - Start Date Column, but concatenates Years, Months . I keep getting a result of days & can’t get the result of 1Y 5M or 6M

In Excel, I use. =CONCATENATE(DATEDIF(STARTDATE,TODAY(),“Y”),"Y ",(DATEDIF(STARTDATE,TODAY(),“YM”)),“M”)

Any suggestions on the rest of this formula…Today() - thisRow.[Start Date]

2

hi @Brandi_Moore , welcome

what about this

image
image1548×479 40 KB

or

image
image2078×442 44.6 KB

the last one - as you can see - counts also the ‘today’.

hope it helps, best, Christiaan

2 Likes
3

Thank you for the effort. I’ll use it.

4

Dear @Brandi_Moore,

I might be wrong, but got the impression that you are looking for a more detailed solution.
Please find the sample below and feel free to copy and use it for your project.

2 Likes
5

Hi @Brandi_Moore ,

this should be fulfilling your request. Please be aware that the Duration output is just text and not a duration format that can be processed by coda.

Best regards

Marius

2 Likes