hi,
thanks tried it but then out put as follows for this example below :
| CT_Prom_Start | CT_Prom_End | Promo_Week_End |
| 24-Nov-17 | 10-Dec-17 | 25-Nov-17 |
| 24-Nov-17 | 10-Dec-17 | 2-Dec-17 |
| 24-Nov-17 | 10-Dec-17 | 9-Dec-17 |
there also needs to be one more row for 16-Dec-17