Issuance vs Redemption dates... Number of days between?

[Tank2000]

Hi there.

Looking for advice on which formulas to use to determine the number days between two spreadsheets.

I have one spreadsheet which contains point issuance information. On this spreadsheet the following fields are present:

-------------------------------

- ID#
- Transaction Date
- Total Points Issued

-------------------------------

On another spreadsheet I have redemption information. On this spreadsheet the following fields are present:

- ID#
- Redemption Date
- Total Points Redeemed

-------------------------------

What I'm trying to determine, is how many days are there between when a participant receives a points deposit (issuance) to when they redeem their points.

Let's use this simple example for demonstration purposes... Let's say I received points on February 1, 2019 of 200. On February 2, 2019, I redeem for 200. The result is that it took me only 1 day to redeem my points.

Here's how this would look like on the 2 spreadsheets...

-------------------------------

Points Issuance Spreadsheet:

- ID# = 91234
- Transaction Date = 2019-02-01
- Total Points Issued = 200

-------------------------------

Redemption Spreadsheet:

- ID# = 91234
- Redemption Date = 2019-02-02
- Total Points Redeemed = 200

-------------------------------

Where I start to run into issues, is when I have participants with multiple issuance and redemption dates.

For example...

-------------------------------

Points Issuance Spreadsheet:

- ID# = 91234
- Transaction Date = 2019-02-01
- Total Points Issued = 200

- ID# = 91234
- Transaction Date = 2019-02-13
- Total Points Issued = 300

- ID# = 91234
- Transaction Date = 2019-02-13
- Total Points Issued = 100

- ID# = 91234
- Transaction Date = 2019-02-15
- Total Points Issued = 200

-------------------------------

Redemption Spreadsheet:

- ID# = 91234
- Redemption Date = 2019-02-02
- Total Points Redeemed = 200

- ID# = 91234
- Redemption Date = 2019-02-17
- Total Points Redeemed = 200

- ID# = 91234
- Redemption Date = 2019-02-18
- Total Points Redeemed = 200

-------------------------------

Any help to address this scenario would be greatly appreciated.

Thanks.

 

[Tank2000]

Here are some links to the sample spreadsheets...

Issuance spreadsheet link... https://app.box.com/s/4fdv9iwzyp9z1k7idq95fa9s2ga1cclw

Redemption spreadsheet link... https://app.box.com/s/4stnt1265ippdtagr6bh7xzu6cvvqlhp

Again, I'm looking to see if there is a formula or VBA that can be applied to the redemption spreadsheet that will let me know how many days between points issued to point redeemed.

Any insight or direction on how to solve for this problem, would be greatly appreciated.

Cheers!