Comparing dates to find data

**sentinela** · 03-24-2009, 10:43 AM

Hello,

I am working on a very challenging spreadsheet at the moment.

On Book1 I have the previous month data and the amount that people owed. On Book2 I have the other amount and some of them started in a different date. On a sheet2 I want the different amount that people owe for this month. So I need a formula that will check the date, and the name on Sheet1, and them check if it is matching with Book1.

I have tried a if statement, but it will be based by cells and not by the data.

Anyone else have any ideas?

Thanks!

**zbor** · 03-24-2009, 11:09 AM

See if you can use this... I did it for some other user today, but if this is good start we can adjust it for your particular problem...

Attachment 39621

**sentinela** · 03-24-2009, 11:30 AM

zbor,

Thank you very much
That helps some...
This is exactly I am trying to do...

Book1
John Smith - $245.00 - 2/10/09
Bill Davies - $650.00 - 2/20/09

On Book2 when I
John Smith - $245.00 - 2/10/09
Bill Davies - $650.00 - 2/20/09
Jane Doe - $100.00 - 3/5/09

Now on Sheet2 I am trying to find out the last day that I charged interest on these people. Some of them came in and some others went out. So this is what I need to do...

Go to Book1 find the names the last date that they were charged and then. Go to Book2 and find if there are any new people, and then on Sheet2 come out with the results.

Thanks!