Ms Excel
This query is : Resolved
15 February 2010
Can any one tell me how to sort by date in ms excell
when i am trying to sort in date format ex:dd/mm/yy then date wise only changed but month not changed in order
will you tell me procedure
when i am trying to sort in date format ex:dd/mm/yy then date wise only changed but month not changed in order
will you tell me procedure
15 February 2010
Try this step >
1. Select the data in column for sorting.
2. Go to Data>Sort and select the column for starting.
It will sort the date format also.
I don't understand about month wise..even the month also includes some date only.
Like if u right March 09, it will take 31.3.09
or if u right Feb,09 then it wil take it as 28.2.09.
and if u sort it in ascending order, then the date of 28.2.09 will preeeced 31.3.09.
I hope it solves ur problem.
1. Select the data in column for sorting.
2. Go to Data>Sort and select the column for starting.
It will sort the date format also.
I don't understand about month wise..even the month also includes some date only.
Like if u right March 09, it will take 31.3.09
or if u right Feb,09 then it wil take it as 28.2.09.
and if u sort it in ascending order, then the date of 28.2.09 will preeeced 31.3.09.
I hope it solves ur problem.
15 February 2010
Thanku but not workout
if dates are 04/01/2009
01/05/2009
03/02/2009
in above case when iam sort : the result is as below
01/05/2009
03/02/2009
04/01/2009
if dates are 04/01/2009
01/05/2009
03/02/2009
in above case when iam sort : the result is as below
01/05/2009
03/02/2009
04/01/2009
15 February 2010
Its working..
be sure that the format of all the dates are same..
dd/mm/yy or mm/dd/yy.
i.e 4/1/2009 shud be 4th Jan
1/5/2009 shud be 1st May
3/2/2009 shuid be 3rd feb.
or if other format is using, then
4/1/2009 shud be 1st April
1/5/2009 shud be 5th Jan
3/2/2009 shud be 2nd March..
BE ENSURE ALL ARE RESPRESENTING SAME FORMAT. IF DIFFERENT FORMAT FOR DIFF DATES..IT WILL NOT WORK.
be sure that the format of all the dates are same..
dd/mm/yy or mm/dd/yy.
i.e 4/1/2009 shud be 4th Jan
1/5/2009 shud be 1st May
3/2/2009 shuid be 3rd feb.
or if other format is using, then
4/1/2009 shud be 1st April
1/5/2009 shud be 5th Jan
3/2/2009 shud be 2nd March..
BE ENSURE ALL ARE RESPRESENTING SAME FORMAT. IF DIFFERENT FORMAT FOR DIFF DATES..IT WILL NOT WORK.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- RATE AND HSN CODE
- TODAY INCOME TAX SITE IS NOT WORKING ANY OFFICIAL EXTENSION
- Portuguese Civil Code IT Return
- LIC maturity claim whether taxable
- Can we choose not to report losses in ITR3 if they cannot be carried forward?
- EMI ISSUE IN HOUSING LOAN OLD REGIME
- TDS AND ITR ISSUE
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
