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.
_________________________
Chad