Month

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.
 
C

Chip Pearson

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
 
F

Frank Kabel

Hi
one way:
enter the formula
=A1
and apply the custom format 'MMMM' to this cell

or use
=TEXT(A1,"MMMM")
 

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

count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Changing contents of cell based on Cell Format 3
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Help!!!! 0
Subtracting time...again 2
I have lost 6 months work, how can i get my file back 1
YTD SUMIF based on current date 3
Paste to excel from word - auto format problem 1

Top