Try here

http://www.mrexcel.com/forum/showthread.php?t=36619

This a formula the will give True False - which you could use

=OR(CELL("format",A1)={"D1","D2","D3","D4","D5"})

Original formula from :

Aladin Akyurek
MrExcel MVP

edvwvw



Ayo wrote:
Is there a function like the ISBLANK function for dates. I am trying to write
and IF statement formular that works like this:
If the value in A1 is a Date then perform calculation else leave blank.

What is the best way to do this.

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200904/1