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

Tank2000

New Member
Joined
Mar 7, 2019
Messages
11
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.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Tank2000

New Member
Joined
Mar 7, 2019
Messages
11
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!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,827
Messages
5,855,877
Members
431,771
Latest member
CoryMelth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top