G
Guest
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
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