T
Tendresse
I have a column (E:E) for Dates of Birth, and the next column (F:F) has a
formula to calculate the age as follows: =(TODAY()-E:E)/365
Cells of column F:F are formatted as "Number" with decimal places "1".
I also have a conditional formatting to highlight cells in that column that
have an age between 0 and 3. the condition reads as follows:
Cell value is BETWEEN 0 AND 3
I also have a cell at the bottom of column F:F that counts the TOTAL number
of children under 3 years of age using the formula: =COUNTIF(F12:F18, "<3")
So far all sound logical. However, something very weird is happening:
Considering TODAY() is 23/05/07, when I enter a date of birth 02/06/04, the
age then appears as 3.0, this age cell gets highlighted accroding to the
Conditional Formatting, and the child gets counted in the TOTAL even though
the formula in the TOTAL cell counts those <3 not those <=3
And if I enter a date of birth 15/05/04, the age cell calculates the age as
3.0, however, the cell doesn't get highlighted according to the Conditional
Formatting and that child doesn't get counted in the TOTAL cell!
How come the values of the age cells are treated differently even though
they are both equal 3.0?
Your assistance will be greatly appreciated.
Tendresse
formula to calculate the age as follows: =(TODAY()-E:E)/365
Cells of column F:F are formatted as "Number" with decimal places "1".
I also have a conditional formatting to highlight cells in that column that
have an age between 0 and 3. the condition reads as follows:
Cell value is BETWEEN 0 AND 3
I also have a cell at the bottom of column F:F that counts the TOTAL number
of children under 3 years of age using the formula: =COUNTIF(F12:F18, "<3")
So far all sound logical. However, something very weird is happening:
Considering TODAY() is 23/05/07, when I enter a date of birth 02/06/04, the
age then appears as 3.0, this age cell gets highlighted accroding to the
Conditional Formatting, and the child gets counted in the TOTAL even though
the formula in the TOTAL cell counts those <3 not those <=3
And if I enter a date of birth 15/05/04, the age cell calculates the age as
3.0, however, the cell doesn't get highlighted according to the Conditional
Formatting and that child doesn't get counted in the TOTAL cell!
How come the values of the age cells are treated differently even though
they are both equal 3.0?
Your assistance will be greatly appreciated.
Tendresse