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

S

Sea Jay

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
 
M

Max

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