Selecting a row from excel from a particular ramge of date

Hi Mahesh,

You are right my excel hasin some rows i checked it has / instead of -.
dd/mm/yyyy instead of dd-mm-yyyy

Hi Mahesh,

I got the problem
the problem is in my transaction date column half of the format is like mm-dd-yyyy and half is like
dd/mm/yyyy. the place from where the / is starting the date format is only getting cahnged
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-02-2017 00:00
12-02-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM

@aamir

ok try with the procedure mentioned above and check whether it is working or not.

Regards,
Mahesh

sure mahesh.

Hi @aamir,

Please don’t create the duplicate posts.

Regards,
Arivu :slight_smile: