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

How to sort my date format

R

RAFI

Member
hi all,

facing a problem regarding date format.
i have a list where date is in general format.
is there any formula by which i can change my date from general to date format.
example- date/month/year is my present format;wanna convert month/date/year format..
is it possible???
 
Many things are possible.
You could get Your answer quicker (many times) after
You have uploaded a Sample File.
... or is this something like from 12/14/2016 to 14/12/2016?
 
when i tried to group my dates monthly in pivot table i found my date column is in general format not in date format. there are so many dates.its very diificult to change one by one..so can i do it by any formula or something??
thanks..
 

Attachments

formula to cell B2 and copy down
=DATE(2000+RIGHT(C4;2);IF(MID(C4;6;1)=".";MID(C4;4;2);MID(C4;4;1));LEFT(C4;2))
NOTE! if for some reason You need to use "," instead of ";" then USE!
 
... because someone didn't want to write September like .09. (written .9.).
There should be 'rules' how to write! Maybe soon someone would write like m.d.yy or whatever combination.
You could try to use 'data validation' ...
 
you can try this.
first select entire column of date and opt format as DD/MM/YYYY.
then press ctrl+h and replace all "." with "/". you will get what you want.
 
One more option to use Text to Column Wizard.
  1. Select your date column and Go to Data
  2. Delimited > Next
  3. Tab > Next
  4. Date > Finish
Regards,
 
if You data range is ... one row ... what would it show?
Screen Shot 2016-10-31 at 10.15.40.png
... and You haven't select nothing to value within Pivot-table?
 
You must log in or register to reply here.
Back
Top