# 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

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

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!

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.

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.

### Which adblocker are you using?

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

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