In Progress

Data Manipulation Excel

I have 2 excel spreadsheets. One contains a list of date ranges and the second one lists dates. I need to loop through the 2nd list and check if the date is included in of the the ranges listed in the 1st spreadsheet.

For instance. File 1 looks like this:

1 2/1/2007 3/1/2007

2 4/1/2007 5/1/2007

3 5/1/2007 6/1/2007

File 2 looks like this:

1 2/15/2007

2 2/18/2007

3 5/2/2007

The result should look like this

1 2/15/2007 1

2 3/15/2007 1

3 5/2/2007 3

Thanks

Skills: Excel

See more: n excel, check data, manipulation, spreadsheet manipulation, excel contains, instance excel, excel instance, excel check, excel file data manipulation, check data excel file, data check, excel manipulation, need excel, 2nd file, data list, check excel, date instance, check dates, check instance, excel loop list, excel list loop, data spreadsheet, check date excel, ranges, excel date

About the Employer:
( 5 reviews ) Brooklyn, United States

Project ID: #234599

Awarded to:

msoftsolution

Hi,we can do it

$30 USD in 0 days
(0 Reviews)
1.0

6 freelancers are bidding on average $35 for this job

kushvyas86

please see pm for details

$30 USD in 1 day
(0 Reviews)
0.0
julio1973

Hi i can do it over 4 hours. Regards

$50 USD in 1 day
(0 Reviews)
0.0
milesf01

Will check it quickly.

$40 USD in 0 days
(0 Reviews)
0.0
jituharjai

The job will be done with 100% accuracy in stipulated time.

$30 USD in 1 day
(0 Reviews)
0.0
nickolaus

Hello. Depending on how exactly dates are stored in cells, it would take from 2 to 4 hours for me to do it. I already have experience with VBA in MSOffice.

$30 USD in 1 day
(0 Reviews)
0.0