I don't think you can have two formats in the same cell. How about adding a
second cell after MON, formatted as m/d? The second cell could simply
reference the MON cell, in the format =D7 (assuming MON is C7).

"tkaplan" wrote in
message ...

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.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile:
http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=465916