Datedif(??

[Pizzio]

I'm looking for a formula that will give me the number of years and months in this format YY.M

 

[awoohaw]

try:

=DateDif(StartDate,EndDate,"M")&"."&DateDif(StartDate,EndDate,"M")

This function has limitations and you should review the conditions where it may provide incorrect results.
Please look at this link:

DATEDIF function - Microsoft Support

Calculates the number of days, months, or years between two dates.

support.microsoft.com

 

[Vogateer]

try:

=DateDif(StartDate,EndDate,"M")&"."&DateDif(StartDate,EndDate,"M")

This function has limitations and you should review the conditions where it may provide incorrect results.
Please look at this link:

DATEDIF function - Microsoft Support

Calculates the number of days, months, or years between two dates.

support.microsoft.com

I'd be surprised if I were right about this, but it looks to me like the first "M" should be a "Y".

=DateDif(StartDate,EndDate,"Y")&"."&DateDif(StartDate,EndDate,"M")

Was that a typo, or am I misunderstanding how that formula works?

 

[awoohaw]

I'd be surprised if I were right about this, but it looks to me like the first "M" should be a "Y".

=DateDif(StartDate,EndDate,"Y")&"."&DateDif(StartDate,EndDate,"M")

Was that a typo, or am I misunderstanding how that formula works?

why would you be surprised? people make typos, my bad.
Thanks for the catch!

 

[Vogateer]

why would you be surprised? people make typos, my bad.
Thanks for the catch!

Because usually I'm the one making typos and missing edge cases! You're one of the people on here typically nailing it the first time.

 

[Cubist]

@awoohaw your formula (with @Vogateer ) double counts the years and months. I think the OP wants the M part to be the remaining fraction of a year.

 

[Vogateer]

@awoohaw your formula (with @Vogateer ) double counts the years and months. I think the OP wants the M part to be the remaining fraction of a year.

Right, so maybe this would be what he wants?

=DATEDIF(startdate,EndDate,"Y")&"."& MOD(DATEDIF(startdate,EndDate,"M"),12)

 

[Dave Patton]

or possibly
=DATEDIF(startdate,EndDate,"Y")&"."& DATEDIF(startdate,EndDate,"ym")

 

[Cubist]

I think this does the same (without rounding).

=YEARFRAC(start,end)

 

[awoohaw]

Because usually I'm the one making typos and missing edge cases! You're one of the people on here typically nailing it the first time.

Thanks, but, i'm not an A lister here. Folks chime in with better, more efficient, and shorter solutions very frequently with me.