Saturday, January 21, 2012

convert a date(dd/mm/yy) to a month in MS Excel

  • Select cell
  • On Formula bar enter the below formula
=CHOOSE(TEXT(A2,Month(A2)),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

if A2 contains 11/12/2012 means that formula returns "Nov".



No comments:

Post a Comment

How to launch a document by clicking a link to the file?

Word: <a href='ms-word:ofe|u|path/to/web/word/document.docx'>Link to document</a> Excel: <a href='ms-excel:o...