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

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...