Dear Himanshu, I guess that the date has to be changed to MMDDYY format because excel recognises MMDDYY as date and not DDMMYY format. Then you try to sort, it would help then.
All the best! -- Good friendship is like the relationship between eye & hand! If the hand is hurt, the eye will cry! & when the eye cries, the hand will wipe the tears!!! With best regards, Mahesh Narasimhan M: +91(0)9899353960 E: maheshde...@gmail.com On 4/18/15, Himanshu Sahu <sahu.himanshu2...@gmail.com> wrote: > Dear Friends, > Please suggest me the option for doing the following in Excel Sheet. > > I have a document containing 20 columns and 4000 rows. > In the column "g" various dates for one event is mentioned. These > dates begin from 1st April 1985 to the 31st march 2015. > The date format is DD/MM/YYYY. > I need to extract data beginning from 1st April 2014 to 31st March 2015. > I tried "sorting" option in descending order, but it is not sorting > data as desired, e.g., after searching 31st March 2015 data, it is > showing the data of 31st march 2014, 31st march 2013 and so on... > So, please suggest the way to get data of above mentioned period only > i.e., 01/04/2014 to 31/03/2015. > > Another problem is also related to the same condition: > > All of these dates which start from 1 to 9 of the month day, are > mentioned in D/M/YYYY format, e.g., 1/1/2015 . Even I tried to make > them uniform manually like 01/01/2015, but the document setting is not > allowing it. > So, here my query is: > 1. How to make this date format uniform like DD/MM/YYYY? > 2. Even without making it uniform, can we extract the data as > mentioned above? If yes, then how? > > Looking for your positive response... > > -- > Thanks and regards > Himanshu Sahu > Reach: 09051055000 > Skype: himanshu.cute4u > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
