Date Format Questions

[Guest]

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]

Hi


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

Arvi Laanemets

 

[Bob Phillips]

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

--

HTH

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