Hi Himanshu, You can change the date to "1-Apr-14" format and apply auto filter. You can activate Date filter submenu and key in the requirements and extract the needed data.
Regards, Swarna. On 4/18/15, Mahesh Narasimhan <[email protected]> wrote: > 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: [email protected] > > > > On 4/18/15, Himanshu Sahu <[email protected]> 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/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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/[email protected]/ To unsubscribe send a message to [email protected] 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..
