Excel help


This query is : Resolved 

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

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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
11 August 2026
COMPLIANCE EXECUTIVE

YMW COMPLIANCE SERVICES LLP

Others

CA Final

View Details
Company
Featured 19 August 2026
Chartered Accountant

apricus india

Pune

CA

View Details
Company
27 August 2026
ACCOUNTANT

CHARUPREETI & CO

Noida

Graduate (Any)

View Details
Company
11 August 2026
Manager / Senior Manager - Statutory Audit

CommerceCareer

New Delhi

CA

View Details
Company
ARTICLESHIP 29 August 2026
Article Assistant

RRPM & ASSOCIATES LLP

Chennai

CA Inter

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details