In Column A I have a Product name and version number. The Version Number can be anywhere between 1 and 50. (For example Carrot v1, Orange v6, Potato v12.
In Column G I have the launch date
In Column L I have a removal date
So for example
So in the asterisk starred cell L2, I want it to display a date 60 Days after the next version of that product launched. So, Potato v3 launched on 4 March 2021, so 60 days after that is 03 May 2021.
The length of the product name is not standard the V number can be 1 or 2 digits (Unfortunately, I cannot make it v01 to keep it consistent)
Anything like Lemon or Aubergine, where that is the current product just needs to remain blank, until a new version of that is launched.
Hope that makes sense!
In Column G I have the launch date
In Column L I have a removal date
So for example
| (ROW NUMBER) | Column A | Column G | Column L | |||
| (PRODUCT NAME) | (LAUNCH DATE) | (REMOVAL DATE) | ||||
| 2 | Potato v2 | 01/02/2021 | * | (The * needs to be 60 days after Potato v3 - 03 May 2021 should be in L2 | ||
| 3 | Lemon v8 | 03/02/2021 | ||||
| 4 | Potato v3 | 04/03/2021 | ||||
| 5 | Aubergine v12 | 06/03/2021 |
So in the asterisk starred cell L2, I want it to display a date 60 Days after the next version of that product launched. So, Potato v3 launched on 4 March 2021, so 60 days after that is 03 May 2021.
The length of the product name is not standard the V number can be 1 or 2 digits (Unfortunately, I cannot make it v01 to keep it consistent)
Anything like Lemon or Aubergine, where that is the current product just needs to remain blank, until a new version of that is launched.
Hope that makes sense!
