Date Format Questions
 

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

Hi


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

Arvi Laanemets

"Mestrella31" wrote in message
...
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

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

--

HTH

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


"Arvi Laanemets" wrote in message
...
Hi


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

Arvi Laanemets

"Mestrella31" wrote in message
...
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