Posted to microsoft.public.excel.misc
|
|
Convert Age to Months
This is great, thank you very much!
Meg
"Jim Thomlinson" wrote:
Use the datedif function something like this...
=DATEDIF(A1, TODAY(), "m")
Here is a link on using datedif
http://www.cpearson.com/excel/datedif.aspx
--
HTH...
Jim Thomlinson
"Meg" wrote:
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
|