Need Month and Day only

B

Bonnie

Hi there. Using E02 on XP. Have a cell that needs to link
to a date cell (01/31/2005) and I need to see just month
and day (January 31). I found the =Month(K2) but can't
figure out how to get the month and day.

I appreciate any help or advice (and believe me, I really
looked in Excel Help first!). Thanks!
 
S

swatsp0p

In your desired cell enter this formula: =K2 and change the Format to
Date:mm/yy
To change the format, click on the main menu Format>Cells, select the Number
tab, click Date and select your desired output from the list on the right.

Good Luck
 
B

Bob Phillips

You could also use

=TEXT(A1,"mmm dd")

--

HTH

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