Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Age Formula
I have a formula that determines a child's age by the month. I noticed
that today 9/16 one of our children turned 1 month old but the answer still says 0. What is wrong with formula. It would be nice if I had one formula instead of two. THe formula can calculate age up to 6 weeks, the in months from 2 months up to 35 months, and then 3 years and up. Can anyone help me? This is the formula I use for the months =IF(C87="","",ROUNDDOWN(((TODAY()-C87)/365*12),0))''= This is the formula I use for the 3 year olds and higher. =IF(ROUNDDOWN(((TODAY()-B9)/365*12),0)=37,ROUNDDOWN(((TODAY()-B9)/ 365*12),0),ROUNDDOWN(((TODAY()-B9)/365),0)) It would be nice to have one formula to calculate all scenarios. |