| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number of days into years/months | Excel Discussion (Misc queries) | |||
| how to convert number of days to months | Excel Discussion (Misc queries) | |||
| convert # of years, months and days | Excel Discussion (Misc queries) | |||
| how to convert 12/10/1970 to years/months/days | New Users to Excel | |||
| How do i convert years to months (formula) | Excel Worksheet Functions | |||
Threaded Mode
