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

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

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.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=383455