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

Tank2000

New Member
Joined
Mar 7, 2019
Messages
8
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Some videos you may like

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
Joined
Mar 7, 2019
Messages
8
Office Version
  1. 2019
Platform
  1. Windows
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,810
Messages
5,525,010
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top