Extracting Month From Date

  • Thread starter Thread starter BenjieLop
  • Start date Start date
B

BenjieLop

My question is:

If entry on Cell A1 (date format) is, e.g., "September 27, 2004
(without the quotes), is there a formula that will give "September
(without the quotes) in Cell B1?

Thank you and regards
 
If it is just the month that you want to show then format the cell as "mmmm"
(without the quotes)

HTH

Sandy
 
In B1, put the formula =A1 and format B1 with the custom number format "mmmm"
 
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

if, then display next cell 4
custom date format 2
Date formatiing - using code to show months 2
How to retrieve the values within cells? 4
date format convert 2
Quarterly Formula 1
Month Formula 4
Return Month & Year of Date Value 1

Back
Top