Spreadsheet: 873459d1719952040-see-returns-within-30-days-from-the-same-customer-test
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | BRING FROM TABLE 1 | USE FORMULA TO CALCULATE NUMBER OF RETURNS PER CUSTOMER
FIRST LAST | Customer ID | Return Date |  |  |  | FIRST LAST | Customer ID | Order Date | Return Date | Delta (diff bn new order date and last return date) | Reordered within 30 days of 1st return | Count Returns after first free return
[NAME] | 729 | 2024-01-21 00:00:00 |  |  |  | [NAME] | 729 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00
[NAME] | 729 | 2024-01-31 00:00:00 |  |  |  | [NAME] | 729 | 2024-01-28 00:00:00 | 2024-01-31 00:00:00
[NAME] | 273 | 2023-11-16 00:00:00 |  |  |  | [NAME] | 273 | 2023-11-14 00:00:00 | 2023-11-16 00:00:00
[NAME] | 183 | 2024-01-18 00:00:00 |  |  |  | [NAME] | 183 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00
[NAME] | 708 | 2024-01-27 00:00:00 |  |  |  | [NAME] | 708 | 2024-01-25 00:00:00 | 2024-01-27 00:00:00
ASHTON [NAME] | 832 | 2024-04-28 00:00:00 |  |  |  | ASHTON [NAME] | 832 | 2024-04-25 00:00:00 | 2024-04-28 00:00:00
AUDREY DORAN | 438 | 2024-05-05 00:00:00 |  |  |  | AUDREY DORAN | 438 | 2024-04-26 00:00:00 | 2024-05-05 00:00:00
AUDREY DORAN | 438 | 2024-05-20 00:00:00 |  |  |  | AUDREY DORAN | 438 | 2024-05-09 00:00:00 | 2024-05-20 00:00:00
AUDREY MACDONALD | 155 | 2023-06-10 00:00:00 |  |  |  | AUDREY MACDONALD | 155 | 2023-06-06 00:00:00 | 2023-06-10 00:00:00
AUDREY MACDONALD | 155 | 2024-01-08 00:00:00 |  |  |  | AUDREY MACDONALD | 155 | 2024-01-06 00:00:00 | 2024-01-08 00:00:00
AUDREY MACDONALD | 155 | 2024-01-18 00:00:00 |  |  |  | AUDREY MACDONALD | 155 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00
[NAME] | 307 | 2024-02-17 00:00:00 |  |  |  | AUDREY MACDONALD | 155 | 2024-03-12 00:00:00
[NAME] | 307 | 2024-03-18 00:00:00 |  |  |  | [NAME] | 307 | 2024-01-11 00:00:00 | 2024-02-17 00:00:00
[NAME] | 307 | 2024-04-24 00:00:00 |  |  |  | [NAME] | 307 | 2024-02-22 00:00:00 | 2024-03-18 00:00:00
[NAME] | 918 | 2024-02-03 00:00:00 |  |  |  | [NAME] | 307 | 2024-04-19 00:00:00 | 2024-04-24 00:00:00
[NAME] | 918 | 2024-02-22 00:00:00 |  |  |  | [NAME] | 918 | 2024-01-31 00:00:00 | 2024-02-03 00:00:00
[NAME] | 918 | 2024-04-12 00:00:00 |  |  |  | [NAME] | 918 | 2024-02-18 00:00:00 | 2024-02-22 00:00:00
CARMEN Y RAMIREZ | 1051 | 2024-04-04 00:00:00 |  |  |  | [NAME] | 918 | 2024-04-08 00:00:00 | 2024-04-12 00:00:00
CAROL MCDONALD | 159 | 2023-11-06 00:00:00 |  |  |  | CARMEN Y RAMIREZ | 1051 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00
CLEMENTINE PERRY | 126 | 2023-07-28 00:00:00 |  |  |  | CAROL MCDONALD | 159 | 2023-11-03 00:00:00 | 2023-11-06 00:00:00
CLEMENTINE PERRY | 126 | 2023-09-21 00:00:00 |  |  |  | CHERYL MULLANEY | 805 | 2024-04-29 00:00:00
CLEMENTINE PERRY | 126 | 2024-01-17 00:00:00 |  |  |  | CLEMENTINE PERRY | 126 | 2023-07-23 00:00:00 | 2023-07-28 00:00:00
CLEMENTINE PERRY | 126 | 2024-02-07 00:00:00 |  |  |  | CLEMENTINE PERRY | 126 | 2023-09-19 00:00:00 | 2023-09-21 00:00:00
DEBORAH LINGOES | 106 | 2023-12-06 00:00:00 |  |  |  | CLEMENTINE PERRY | 126 | 2023-12-20 00:00:00 | 2024-01-17 00:00:00
DEBORAH LINGOES | 106 | 2024-03-15 00:00:00 |  |  |  | CLEMENTINE PERRY | 126 | 2024-01-18 00:00:00 | 2024-02-07 00:00:00
DEBORAH VENNER | 828 | 2024-02-08 00:00:00 |  |  |  | CLEMENTINE PERRY | 126 | 2024-04-20 00:00:00
[NAME] | 1094 | 2024-04-11 00:00:00 |  |  |  | DANIEL MORIN | 870 | 2024-04-29 00:00:00
DELPHINE HAMILTON | 169 | 2023-08-25 00:00:00 |  |  |  | DEBORAH LINGOES | 106 | 2023-12-04 00:00:00 | 2023-12-06 00:00:00
[NAME] | 67 | 2023-06-29 00:00:00 |  |  |  | DEBORAH LINGOES | 106 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00
[NAME] | 811 | 2024-03-26 00:00:00 |  |  |  | DEBORAH VENNER | 828 | 2024-02-05 00:00:00 | 2024-02-08 00:00:00
DEREK MCCLEARY | 964 | 2024-03-13 00:00:00 |  |  |  | [NAME] | 1094 | 2024-04-09 00:00:00 | 2024-04-11 00:00:00
DEREK MOFFETT | 424 | 2023-10-18 00:00:00 |  |  |  | DELPHINE HAMILTON | 169 | 2023-08-21 00:00:00 | 2023-08-25 00:00:00
DEREK MOFFETT | 424 | 2024-02-16 00:00:00 |  |  |  | [NAME] | 67 | 2023-06-27 00:00:00 | 2023-06-29 00:00:00
DIANE FAUBERT | 508 | 2023-12-22 00:00:00 |  |  |  | [NAME] | 811 | 2024-03-24 00:00:00 | 2024-03-26 00:00:00
[NAME] | 180 | 2023-06-08 00:00:00 |  |  |  | DEREK MCCLEARY | 964 | 2024-03-11 00:00:00 | 2024-03-13 00:00:00
[NAME] | 546 | 2024-03-01 00:00:00 |  |  |  | DEREK MOFFETT | 424 | 2023-10-14 00:00:00 | 2023-10-18 00:00:00
[NAME] | 546 | 2024-03-07 00:00:00 |  |  |  | DEREK MOFFETT | 424 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00
EILEEN DYKENS | 800 | 2024-02-01 00:00:00 |  |  |  | DIANE FAUBERT | 508 | 2023-12-17 00:00:00 | 2023-12-22 00:00:00
[NAME] | 203 | 2023-08-19 00:00:00 |  |  |  | [NAME] | 180 | 2023-06-05 00:00:00 | 2023-06-08 00:00:00
EVELYN EGAN | 590 | 2023-11-18 00:00:00 |  |  |  | [NAME] | 546 | 2024-02-22 00:00:00 | 2024-03-01 00:00:00
FLORENCE NEE | 871 | 2024-04-16 00:00:00 |  |  |  | [NAME] | 546 | 2024-03-01 00:00:00 | 2024-03-07 00:00:00
FRANCESCO VENUTO | 911 | 2024-03-21 00:00:00 |  |  |  | EILEEN DYKENS | 800 | 2024-01-31 00:00:00 | 2024-02-01 00:00:00
FRANCESCO VENUTO | 911 | 2024-04-08 00:00:00 |  |  |  | [NAME] CEFALO | 860 | 2024-02-10 00:00:00 | Ob
FRANCESCO VENUTO | 911 | 2024-04-27 00:00:00 |  |  |  | [NAME] | 203 | 2023-08-16 00:00:00
[NAME] | 787 | 2024-02-12 00:00:00 |  |  |  | EVELYN EGAN | 590 | 2023-11-11 00:00:00
[NAME] | 732 | 2024-01-01 00:00:00 |  |  |  | FLORENCE NEE | 871 | 2024-04-12 00:00:00
[NAME] | 732 | 2024-01-26 00:00:00 |  |  |  | FRANCESCO VENUTO | 911 | 2024-03-19 00:00:00
GEORGENE GILBERTI | 962 | 2024-03-01 00:00:00 |  |  |  | FRANCESCO VENUTO | 911 | 2024-04-04 00:00:00
GEORGENE GILBERTI | 962 | 2024-04-14 00:00:00 |  |  |  | FRANCESCO VENUTO | 911 | 2024-04-24 00:00:00
GERTRUDE STONE | 56 | 2023-10-12 00:00:00 |  |  |  | FRANCESCO VENUTO | 911 | 2024-04-29 00:00:00
GERTRUDE STONE | 56 | 2023-10-15 00:00:00