serge
Well-known Member
- Joined
- Oct 8, 2008
- Messages
- 1,419
- Office Version
- 2007
- Platform
- Windows
Hi,
I have those 2 formulas.
This one calculate birthdate.
=DATEDIF(B8,C8,"Y")&" Ans "&DATEDIF(B8,C8,"YM")&" Mois "&C8-EDATE(B8,DATEDIF(B8,C8,"M"))&" Jours"
This one the days remaining before the birthdate.
=DATEDIF(TODAY(),EDATE(B9,(YEAR(NOW())-YEAR(B9)+1)*12),"ym")&" Mois "&DATEDIF(TODAY(),EDATE(B9,(YEAR(NOW())-YEAR(B9)+1)*12),"md")&" Jours"
I'm looking for a formula that will calculate birthdate before 1900 is that possible ?
Thank you.
I have those 2 formulas.
This one calculate birthdate.
=DATEDIF(B8,C8,"Y")&" Ans "&DATEDIF(B8,C8,"YM")&" Mois "&C8-EDATE(B8,DATEDIF(B8,C8,"M"))&" Jours"
This one the days remaining before the birthdate.
=DATEDIF(TODAY(),EDATE(B9,(YEAR(NOW())-YEAR(B9)+1)*12),"ym")&" Mois "&DATEDIF(TODAY(),EDATE(B9,(YEAR(NOW())-YEAR(B9)+1)*12),"md")&" Jours"
I'm looking for a formula that will calculate birthdate before 1900 is that possible ?
Thank you.