Have a Question?

If you have any question you can ask below or enter what you are looking for!



Excel: changing date format

Hi,

I want to change the below date in date format e.g (03/10/2011) and Then change the format of the date in (10-Mar-011)


Date
10.03.2011
11.03.2011
10.03.2012
11.03.2012
10.03.2013
11.03.2013

  Sachin Yadav

Suppose your date is in cell A1..put the below monster in B1

DATE(RIGHT(A1,4),MID(A1,FIND(".",A1)+1,FIND(".",A1,FIND(".",A1)+1)-FIND(".",A1)-1),LEFT(A1,FIND(".",A1)-1))

  Asheesh Mattoo       17 Jul 2016       0       0     

Hi, 

you are right Asheesh however we have simple formula for the same .

 just try below formula.

=TEXT(J14,"DD-MMM-YYYY")


  Rakesh Sharma       25 Jul 2016       0       0     

Rakesh - Why dont you try checking the both formulae in excel and see the difference.

  Asheesh Mattoo       31 Jul 2016       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any