I'm confused!
If the birth date is 12/15/2008 and today is 1/6/2010 then their age in
(full) months is 12. How do you get 24 or 25? They wouldn't be 24 months old
until 12/15/2010.
See if this does what you want:
A1 = birth date
=DATEDIF(A1,TODAY(),"m")
See this:
http://www.cpearson.com/Excel/datedif.aspx
--
Biff
Microsoft Excel MVP
"Meg" wrote in message
...
Hi - I would like to calculate a child's age into months. For example, if
a
child is 1 year old, the cell would read '12' months old.
What's more important, I don't want to round up to the nearest month. So,
if a child turned 12months on 12/15/09 (born 12/15/08) and today is
1/6/2010,
I would like it to round down to 24months.
It would only turn 25months if today was 1/15/2010.
Regards, Meg