Need one cell to show "March" based on another cell "3/16/04"

  • Thread starter Thread starter HandiMann
  • Start date Start date
H

HandiMann

I am attempting to have one cell display current month("March") based o
another cell having a date. ("3/16/04") Is this possible? :confused:

Thanks in advance for any assistance
 
If you have A1 = 3/16/04. In B1 put =A1

and you want B1 = "March" go to Format, Cells and then pick Custom. I
type put mmmm


M
 
HandiMann, here is one way, with date in A1 =TEXT(A1,"mmmm")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Back
Top