Since 8/4/2005 was a Thursday, I 'm pretty sure that's not what the OP
intended, but if it were, it would be a bit simpler to use

=UPPER(TEXT(A1+3,"ddd m/d"))

In article . com,
"Dave O" wrote:

Here's one way to do it:
="MON "&TEXT((PeriodStart+3),"m/d")
The TEXT() function displays the numerical date value in the date
format you desire.

However, if MON is meant to indicate Monday, your period may not always
start on the prior Friday. If you need to capture the 3-letter
abbreviation in your formula, use this:
=TEXT(PeriodStart+3,"ddd")&" "&TEXT((PeriodStart+3),"m/d")