Hi Everybody,

Using IF() function, how can i check whether a cell contains Date value or
not.

Ex.( if A1 is equal to date then 'OK' else 'Pls enter date')

Regards

Inspired by a previous Dave Peterson post ...

Try in B1:
=IF(A1="","",IF(LEFT(CELL("format",A1),1)="D","OK" ,"Pls enter date"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nad" wrote:
Hi Everybody,

Using IF() function, how can i check whether a cell contains Date value or
not.

Ex.( if A1 is equal to date then 'OK' else 'Pls enter date')

Regards