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

  • Thread starter Thread starter Munchkin
  • Start date Start date
M

Munchkin

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!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
How to convert MM/DD/YYYY to Month 2
change DD/MM/YY to MM/DD/YY 6
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
convert Julian date to DD/MM/YYYY 7
Changing date to eliminate day in format mm/dd/yyyy 1

Back
Top