How i Sort birthdate year wise in excel sheet?

In this area it is not possible for me to make u understand the things. anyways, if u know Microsoft Excel well, just go through below hints & do little experiment, u will do it.

1. select the whole column.

2. press "Alt>D>E>E"

3. this will open "convert text to column wizard.

4. choose fixed width, click next

5. divide the column as per ur requirements.> Finish.

this will divide ur dd,mm & yy in seperate columns.

6. Then use "Concatenate" function to rearrange the delimited data into 1 single column again as per ur requirement.

7. now u will have the date in mm/dd/yy. sort it...

Sorry for this little help. good luck...

With spreadsheets and databases, always put info in separate fields/columns. In this case, you need a separate column for the years, then sorting will be easy.

No i do no longer... yet only as others don't have a say in how I improve my childrens, I don't have a say in how others improve their childrens. i'm against indoctrination yet i won't be able to be sure a thank you to combat it without removing the freedoms of others. I recommend what if somebody instructed you it became into incorrect to allow your infants play with Ninja turtles action figures because of the fact it advocates vigilantism? So at the same time as my own opinion is that teachings in the bible directed in the direction of youthful infants that glorify the violence and genocide in the bible utilising action figures are certainly incorrect.. i won't overlook that human beings might think of the comparable approximately many different action figures and the ideals they signify. as quickly as you initiate there it won't end at that, notably quickly any violent action figures would be banned.. as an occasion i think of Bratz dolls coach ladies to be self-based and shallow, yet is it my place to tell human beings they might't purchase them for their infants? No it is not. i does no longer choose somebody else telling me what my childrens can play with it truly is acceptable, so I won't do it to human beings.