So I am trying to create a basic daily finances tracker using google sheets. And I want to be able to have it so that yearly tabs reference a template sheet that allows you to change the year on each new tab.
However I can't figure out how to add a changeable year value in a seperate cell to the month and day of the main column and have it autofill out the month and days so that if you change the year it will change the year value all the way down the column.
For example "01/01/" & A2, would equal 01/01/2022, and still have the option to change the year and have it go all the way through the chart
I have tried using Indirect, and concantenation using & but possibly not correctly, any help would be appreciated