Hello,

I would like to have a user input the year (yyyy) only into a cell and based on their input have the adjacent cell populate with the upcoming year.

Example:
B6 2008 (user input) --- C6 2009 (automatically populates to the next year)

How do I configure the cells to replicate the example above.

Thanks,
Lotus