Date Format Questions

Mestrella31 · Jan 17, 2005

how do I get this
=((DATE(2005,12,30))&" YTD")

to look like this

Dec 05 YTD

Right now I have a Cell that look like : 38716 YTD

Arvi Laanemets · Jan 17, 2005

Hi

=TEXT(DATE(2005,12,30),"mmm dd")&" YTD"

Arvi Laanemets

Bob Phillips · Jan 17, 2005

or you could just format the cell as mmm dd \YT\D

--

HTH

RP
(remove nothere from the email address if mailing direct)