DATEDIF formula with TODAY's date

[janema]

I am trying to pull the number of years and months between today's date and a previous date, but something keep erroring out in my formula. I'm sure it's a very easy fix, but I just can't seem to figure it out. Help please. Thank you so much.

I am using the current formula: =DATEDIF(K68,TODAY())&"y"&DATEDIF(K68,TODAY()),"ym")$"Mos"

 

[shift-del]

Hi

For years:

=DATEDIF(A1,TODAY(),"y")

For months:

=DATEDIF(A1,TODAY(),"ym")

 

[Alex Blakenburg]

I suspect that you will need that packaged up a bit:

=DATEDIF(K68,TODAY(),"y") & " y "&DATEDIF(K68,TODAY(),"ym") & " Mos"

 

[janema]

I suspect that you will need that packaged up a bit:

=DATEDIF(K68,TODAY(),"y") & " y "&DATEDIF(K68,TODAY(),"ym") & " Mos"

Thank you so much! This worked beautifully.

 

[Alex Blakenburg]

Thanks for letting us know. Glad @shift-del and I could help.