How do I +20
I have a column labeled - "year updated"
In the first cell under it I put 2020 from a drop down menu
In the next column over and in the cell next to it I want to apply (year updated column cell 1) the (2020) cell
and add 20 to that 2020. I have the other column I am trying to populate set up as text/number.
So when I applied it will have read the 2020 and added 20 to it and the cell will now have 2040 in it.
Any suggestions on how to accomplish this would be greatly appreciated!
Thank you so much!
Help Article Resources
Check out the Formula Handbook template!