Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Age Formula
hi all,
If I am using the formula below to calculate the age when entering the date of birth in column A:A =DATEDIF(A:A,TODAY(),"y") & "Y " & DATEDIF(A:A,TODAY(),"ym") & "M " & DATEDIF(A:A, TODAY(), "md") & "D" The age then appears as in: 9Y 3M 15D I need to write 2 formulas in the end of that age column. One to count the number of children who are under 3Y 0M 0D, and one for children who are between 3Y 0M 0D and 10Y 0M 0D (inclusive). Any ideas? cheers, Tendresse |