get mm-dd only from another cell with mm-dd-yyyy
 

How do I do this?

A1 = 02-01-2009. I want A4 to copy just the month & day of A1.

I'm sure it's super easy, but I can't seem to figure out how to do it -
thanks!

get mm-dd only from another cell with mm-dd-yyyy
 

You could keep it a date and just show the stuff you want:
=A1
and give it a nice format (MMM-DD)

or make it text
=text(a1,"mmm-dd")

It kind of depends on why you want to do this.

Munchkin wrote:

How do I do this?

A1 = 02-01-2009. I want A4 to copy just the month & day of A1.

I'm sure it's super easy, but I can't seem to figure out how to do it -
thanks!

--

Dave Peterson

get mm-dd only from another cell with mm-dd-yyyy
 

=month(a1) & "--" & day(a1)

(just to show another way)

Munchkin wrote:

How do I do this?

A1 = 02-01-2009. I want A4 to copy just the month & day of A1.

I'm sure it's super easy, but I can't seem to figure out how to do it -
thanks!

--

Dave Peterson