Originally Posted By: Attack
When A1 is a date this formula returns "SENT" otherwise nothing.

=IF(AND(ISNUMBER(A1),LEFT(CELL("format",A1),1)="D"),"SENT", "")


My Google Foo is good.


Wish I had some Google Foo today smile

I've found a much simpler/cruder way to achieve what I wanted but thanks guys.