- Registration date
- Sunday September 12, 2010
- Last seen
- February 25, 2021
So if A = 2015, then B is probably 2016 and so on.
We need to create a list for that. So one column contains A, B, C.... and the other 2015, 2016, 2017 and so on.
In the following formula your value is placed in A1 and the list is located in columns K and L:
Format the formula cell as date in the desired format.