count occurances of years between two year brackets eg >24 & <50

[Guest]

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

 

[Max]

Try: =IF(ISBLANK(L28),"",DATEDIF(L28,$IV$65536,"y")+2)
where IV65536 contains: =TODAY()

 

[greg7468]

Hi,
try using this

=IF(ISBLANK(L28),"",DATEDIF(L28-NOW()+2,"y"))

Then you can use the countif.

look at

http://www.cpearson.com/excel/datedif.htm

HTH.