Hi all,
Hoping you will be able to assist with this query. Relevant variables are shown in (' ') below, example data at the bottom.
I have a set of data where we have a start date, for example a voucher issued ('Issue Date') on the 10th April 2024.
This voucher can be valid ('Duration') for various amounts of time, for example 5 days, however the 5 days would start from the day after the issue date.
So if the voucher was issued on the 10th April, the 5 day duration would commence from the 11th April 2024.
These 5 days do not include weekends, so will only consider Monday to Friday.
This means the voucher would be valid up to and including 17th April 2024 and will expire ('Expiry Date') from 18th April 2024. Please create a new column for this.
In another new column ('Commentary'), if the voucher has not reached the expiry date, it will return "within date", if the voucher is on or past the expiry date it will return "out of date".
Thank you in advance for your help and I look forward to your responses.
| Issue Date | Duration |
| 13/02/2024 | 1 |
| 13/02/2024 | 1 |
| 13/02/2024 | 5 |
| 13/02/2024 | 1 |
| 13/02/2024 | 9 |
| 06/02/2024 | 8 |
| 12/02/2024 | 2 |
| 12/02/2024 | 2 |
| 12/02/2024 | 2 |
| 13/02/2024 | 3 |
| 13/02/2024 | 1 |
| 13/02/2024 | 4 |
| 13/02/2024 | 1 |
| 12/02/2024 | 2 |
