excel training seminar - Calculated age of person each day

Hi Ruth,,

I'd go about that in a different way.

First of all, in the column you want the formula to be in, format the column as a number. To do this, highlight the whole column then select format > cells... then choose number and put the decimals figure from 2 to 0.

Then try typing this in the top cell of the row you want:

=IF(today()-C1<=730,1,"")

where C1 is the child's date of birth.

it's saying that if the child's DOB is less than or equal to 730 (the number of days in 2 years), display 1, otherwise display nothing. Then you can count the number of 1's by typing in another cell =sum(D:D) for instance if your formula is in column D