Hello
In my workflow I want to add a numeric value (days [in V-String]) to a set date (28/06/2024) to create a new column with the updated date. As an example the output for the first row should be 28/06/2025 Refer attached excel file
| V_String | Byte | String | Byte | Date | V_String |
| CoB Date | Tenor | Buckets | Tenor Group | Date_Time Out | Days |
| 28/06/2024 | 1 | 1Y | 2 | 28/06/2024 | 365 |
| 28/06/2024 | 2 | 2Y | 3 | 28/06/2024 | 730 |
| 28/06/2024 | 3 | 3Y | 4 | 28/06/2024 | 1095 |
| 28/06/2024 | 4 | 4Y | 5 | 28/06/2024 | 1460 |
| 28/06/2024 | 5 | 5Y | 6 | 28/06/2024 | 1825 |
| 28/06/2024 | 7 | 7Y | 7 | 28/06/2024 | 2555 |
| 28/06/2024 | 10 | 10Y | 8 | 28/06/2024 | 3650 |
| 28/06/2024 | 15 | 15Y | 9 | 28/06/2024 | 5475 |
| 28/06/2024 | 20 | 20Y | 10 | 28/06/2024 | 7300 |
| 28/06/2024 | 25 | 25Y | 11 | 28/06/2024 | 9125 |
| 28/06/2024 | 30 | 30Y | 12 | 28/06/2024 | 10950 |
The table above is from my workflow, per the attached excel sheet I'm trying to create formula =$B$1+365*A6 and have output in date format.
Any help is much appreciated.
Thanks!
Sures
