Forum Discussion
Solved
Age calculation
I have a list of dates of birth from a membership spreadsheet. Is there a formula to give me ages of members against current date? Thanks in advance.
Do you have a formula that would calculate age in months? i.e. infants for a daycare spreadsheet based on DOB and today's date?
- thank you - it "sorta worked" I wanted the formula to show me in one cell for example:
18 months should show as 1 year, 6 months (if it's possible)
thanks=DATEDIF(DOB,TODAY(),"y")&" year(s), "&MOD(DATEDIF(DOB,TODAY(),"m"),12)&" month(s)"
- OK - THANKS - I figured out my mistake - it works now..... THANK YOU!
