One way:

=TEXT(A1+3,"\MON m/d")

In article ,
tkaplan wrote:

I have a cell named PeriodStart.
In a different cell i want it to say "MON" followed by the date of
PeriodStart+3 in the format of m/d. So for example is period start is
8/1/2005, i want the cell to say "MON 8/4"
I did concatenate("MON ",PeriodStart+3) and it's returning MON followed
by the serial number. How do i format the serial number to give me the
date value?

Thank you.