To calculate the age in months for the current year, the formula is:
=DATEDIF(C3,NOW(),”ym”)
And therefore, to state the age in this type of format: “24 years, 8 months” the formula is:
=DATEDIF(C3,NOW(),”y”) &” years, “&DATEDIF(C3,NOW(),”ym”)&” months.”
No! Don’t type it all in, copy and paste it from here. I always do, life’s too short to have to reinvent formulas like this.