muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
I'm trying to construct a workbook where it will automatically add a year as time passes. In column A I have the years 2015 through 2022 in rows 1 through 8 and in cell B1 I have the formula =year(today()). When we get to 1/1/2023 i'd like it to add 2023 automatically in cell A9 and subsequent years to also fill as time goes on. Is there a way to accomplish this?
Thanks
Thanks