is D2 a proper date or is it text?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PWK" wrote in message
...
Hello All

=IF(ISBLANK(D2),"",TEXT(D2+3,"ddd"),IF(D2="Sun","M on",D2)))

I am using this function in a worksheet to insert day of week. When
the day "Sun" occurs I want "Mon" to show in the cell instead (I get a
too many argument error). I get very confused with nested functions.
Thanks for your help.