Please TOP post. A formula in cell L2 cannot change itself. You need to give
a better explanation.

Let me add to this. My formula is in cell L2 my formula should read
=IF(ISBLANK(D2),"",TEXT(D2+3,"ddd"),IF(L2="Sun","M on",L2))) as I said
I am confused.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PWK" wrote in message
...
On Dec 19, 8:37 am, PWK wrote:
On Dec 19, 8:26 am, "Don Guillett" wrote:





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.- Hide quoted text -

- Show quoted text -

Don,
Thanks for your reply.
It is a date, in this case 11/13/2008- Hide quoted text -

- Show quoted text -

Let me add to this. My formula is in cell L2 my formula should read
=IF(ISBLANK(D2),"",TEXT(D2+3,"ddd"),IF(L2="Sun","M on",L2))) as I said
I am confused.