Excel 2016, formatting a cell with just a year

mikeb7500

Board Regular
Joined
Jul 30, 2014
Messages
73
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!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,021
Office Version
2016
Platform
Windows
Put in the first cell and fill down:

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

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
9,690
Office Version
2019
Platform
Windows
You could just put =YEAR(TODAY()) in A1, then =A1+1 in A2 and fill down.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,181
Messages
5,472,984
Members
406,842
Latest member
Nay83

This Week's Hot Topics

Top