Months and Days Until Next Birthday - 2019 update

[Worf99]

Hi,
I was looking for a formula to calculate Months and Days Until Next Birthday.
I found this thread

https://www.mrexcel.com/forum/excel-questions/355165-months-days-until-next-birthday.html

It works well, unless the birthday month and day are the same as today.

In that case (e.g. birthday 05/03/1974, today 05/03/2019) I get 12 months instead of "zero".
How can I refine the formula?

Thank you very much!

Matt

 

[Rick Rothstein]

Maybe this way...

=IF(A2=B2,"0 m 0 d",DATEDIF(B2,A2,"m") & " m " & DATEDIF(B2,A2,"md") & " d")

 

[Worf99]

Thank you!