Sort Dates with a formula

I need to list the dates as starting from choosen cell and sort by Z-A.
In attached file explained.

Thanks in advance for any help and reply.

Regards,
turist

Originally Posted by XOR LX

Hi,

In A3 and copy down:

=MAX(INDEX((NOT(ISNUMBER(MATCH(Sheet2!$A$2:$A$21,Sheet1!$A$2:$A2,0)))*Sheet2!$A$2:$A$21),,))

Regards

Works only sort all dates :
If you change Control date as 10/02/2013 (or 02/10/2013) you will see the date value is wrong in A3 cell .
Could you please check, and correct the formula.
Regards,
turist

Originally Posted by vorabha

kindly use in in Cell a2 and copy down

Please Login or Register  to view this content.

Vorabha

Works only sort all dates :
If you change Control date as 10/02/2013 (or 02/10/2013) you will see the date value is wrong in A3 cell .
Could you please check, and correct the formula.
Regards,
turist

Originally Posted by XOR LX

Ah, apologies. It wasn't clear from your original post. Try instead (in A3):

=IFERROR(1/(1/(MAX(INDEX((Sheet2!$A$2:$A$21<MIN(Sheet1!$A$2:$A2))*(Sheet2!$A$2:$A$21),,)))),"")

Regards

Great, now works.

Thanks a lot.