Hi Julie
wanted to write
ISNUMBER
Thanks for the correction

--
Regards
Frank Kabel
Frankfurt, Germany
"JulieD" schrieb im Newsbeitrag
...
Hi Frank

i thought the ISDATE() can only be used in VBA?

Cheers
julieD

"Frank Kabel" wrote in message
...
Hi
try
=IF(AND(A32="value 2",ISDATE(V32),COUNTIF(C77:C1000,BC1)),"Update","n ot
update")

"Pat" wrote:

In sheet P05 if A32 contains the value 2 and V32 contains a date and BC
matches sheet CC04 C77:C1000, return "Update"

Anyone know the formula for this?

Thanks if you can be of help.
Pat