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