Time remaining to birth date.

[serge]

I have this formula that calculate the time remaining before a birth date but it's wrong somewhere, can someone fix it please ?

Thank you.

=DATEDIF(TODAY(),EDATE(B4,(YEAR(NOW())-YEAR(B4)+1)*12),"ym")&" Mois "&DATEDIF(TODAY(),EDATE(B4,(YEAR(NOW())-YEAR(B4)+1)*12),"md")&" Jours"

 

[Fluff]

Your formula works for me with that date, but from the MS website

Important: We don't recommend using the "MD" argument, as there are known limitations with it. See the known issues section below.

DATEDIF function - Microsoft Support

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

support.office.com

 

[serge]

Thank you Fluff,

What I am saying is in E4 shouldn't it be 3 months 26 Days ? instead of 116 days !

 

[Fluff]

With a start date of 3rd Jan 95 you should get 3 days (on 31st Dec 19) not 3 months 26 Days, which is what I get. (or 2 days from today)

Book1
	A	B	C	D	E
1
2		01/01/2020
3
4		03/01/1995			0 Mois 2 Jours
Dup

Cell Formulas
Range	Formula
B2	B2	=TODAY()
E4	E4	=DATEDIF(TODAY(),EDATE(B4,(YEAR(NOW())-YEAR(B4)+1)*12),"ym")&" Mois "&DATEDIF(TODAY(),EDATE(B4,(YEAR(NOW())-YEAR(B4)+1)*12),"md")&" Jours"

 

[serge]

Thank you Fluff.You are right.

 

[Fluff]

You're welcome & thanks for the feedback