Thread: get mm-dd only from another cell with mm-dd-yyyy
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote