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

#### Tank2000

##### New Member
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...

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

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

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

- 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...

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

- 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

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

- 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.

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### Tank2000

##### New Member

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!

Replies
1
Views
73
Replies
6
Views
395
Replies
8
Views
754
Replies
4
Views
261
Replies
2
Views
320