Excel help
This query is : Resolved
Mukesh Katara
(Querist)
17 October 2012
If dates appear in DD-MM-YYYY and MM-DD-YYYY in a range of data and sorting chronologically is required, use DAY, MONTH and YEAR commands to split the dates and then use CONCATENATE command to merge them and format the final output cells as DATE cells.
Thank u in advance
Thank u in advance
17 October 2012
What is your query??
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
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- Tax on Amount transferred in HUF Account
- Nursery business
- GST input credit on commercial property
- GST REFUND ISSUE ON PURCHASE OF PLANT AND MACHINERY
- Working on Gold wastage during Melting of old gold jewellery
- TDS on Dashcam rent and allied services
- TDS- 2026-27 Q1 Correction
- Import Order Cancelled.
- Intimation under section 245
- Capital Gains Tax on Inherited Mutual Fund
- IMS (import of goods) ITC related
- Subject: Legal Remedy for Removal of Income Tax Demand for AY 2024–25 – Charitable Trust
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
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
