Convert Age to Months
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 |
Convert Age to Months
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 |
Convert Age to Months
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 |
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 |
All times are GMT +1. The time now is 01:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com