Try: =IF(ISBLANK(L28),"",DATEDIF(L28,$IV$65536,"y")+2)
where IV65536 contains: =TODAY()
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sea Jay" <Sea wrote in message
...
Could anybody try to help with a calculation. I have calculated ages with
column formatted to yy
=IF(ISBLANK(L28),"",($IV$65536-L28)
- '$IV$65536 being Now()+2

With the column being formatted to yy, I cannot use the COUNTIF function
to
calculate the occurances of ages - I think this is because it is not a
number

Could anybody please make suggestions on how to format the cells to enable
the use of a similar if not the COUNTIF function

PS I can get COUNTIF to work when the age is manually input, but not
calculated