Need Month and Day only
 

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!

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 FormatCells, select the Number
tab, click Date and select your desired output from the list on the right.

Good Luck


"Bonnie" wrote:

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!

You could also use

=TEXT(A1,"mmm dd")

--

HTH

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


"swatsp0p" wrote in message
...
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 FormatCells, select the
Number
tab, click Date and select your desired output from the list on the right.

Good Luck


"Bonnie" wrote:

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!