Excel 2016, formatting a cell with just a year

[mikeb7500]

I would like to format a cell with JUST this year, 2019, so that it automatically changes to 2020 next year, and subsequent years.

Followed by cells that I would like to list as, the next years that changes also automatically.

This Year Next Year

2019 (<=formatted cell for current year) (would automatically change to next year=>) 2020

2020 ------------------------------------------------------------------------------------------ 2021

2021 -------------------------------------------------------------------------------------------2022

2022 ------------------------------------------------------------------------------------------ 2023

2023 -------------------------------------------------------------------------------------------2024

2024 --------------------------------------------------------------------------------------------2025

2025 --------------------------------------------------------------------------------------------2026

Is there anyway to do this? Thanks in Advance!

 

[footoo]

Put in the first cell and fill down:

=TEXT(TODAY(),"yyyy")+ROW(A1)-1

 

[mikeb7500]

Put in the first cell and fill down:

=TEXT(TODAY(),"yyyy")+ROW(A1)-1

Thanks for the help...works GREAT!

 

[jasonb75]

You could just put =YEAR(TODAY()) in A1, then =A1+1 in A2 and fill down.