Date Format

Changing the date format : 

=date(right(A2,4),mid(A2,4,2),mid(A2,1,2))

Step 1

Step 2

Step 3

How to select only Month in a date format:

=TEXT(A2,"mmm")

Step 1











Step 2












Note: If you add YYY then you can get year (example: Mar 2015) =TEXT(A2,"mmm yyy")