Help Pls...

N

Nad

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
 
M

Max

Inspired by a previous Dave Peterson post ...

Try in B1:
=IF(A1="","",IF(LEFT(CELL("format",A1),1)="D","OK","Pls enter date"))
 
Top