Month

  • Thread starter Thread starter ES
  • Start date Start date
E

ES

Is there a formula to take a complete date and just have
the month return? If I have 07/23/04, is it possible to
have the word "July" appear in a cell? I have tried
adding the function TEXT to the beginning and it is not
working. Thanks again.
 
Try the following formula, where A1 contains the date:

=TEXT(A1,"mmmm")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi
one way:
enter the formula
=A1
and apply the custom format 'MMMM' to this cell

or use
=TEXT(A1,"MMMM")
 
Back
Top