Excel - extract month from date time value

Hi


I have a field in excel with datetime values like 1/3/2017 7:42:00 AM
. How can I extract the month portion of it?
LuckyLucksAsked:
Who is Participating?
 
AlanConsultantCommented:
Hi,

Alternatively, if you want the month as a word, and the date is in A1:

=TEXT(A1,"MMM") = "Mar"

OR

=TEXT(A1,"MMMM") = "March"


Alan.
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
=Month(cell)

or

=Month("1/3/17 7:42:00 AM")
0
 
Roy CoxGroup Finance ManagerCommented:
Do you want to extract the month and why?

You can simply Format the cells as "mmm" or"mmmm"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.