• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pick Month out of a Date

S

Shazz

Member
Hello All,

I Have a Cell that has todays date in it "20 March 2017", I would like another cell to show just the Month i.e "March", is this possible at all??

Shazz
xx
 
Hi ,

There are two ways to do this , one by using a data conversion formula , another by using a simpler formula , but changing the cell format.

Using a formula such as :

=TEXT(date , "mmmm")

will display the text string March in the cell which contains this formula.

Using a formula in B1 such as :

=A1

where A1 contains the date , and then formatting this cell B1 to mmmm will display March in B1 , even though B1 will contain a number 42814 ,which is equivalent to the date 20 March 2017.

Narayan
 
You must log in or register to reply here.
Back
Top