Automating Date Headers for printable monthly attendance sheets
test sheet
Trying to figure out why my GoogleSheets Date formula is not working
I have my Order Date in Column A, and Column B which has the number of years to add Column A.
Say the Date in Column A is: 1/1/2024, and the number in Column B is 10.
Ideally, I want the formula to show: =Date((year(A2+B2),month(A2),day(B2+5)), which gives 1/6/2034.
However, the formula is not working. I ensured Column A is formatted to Date in the Format options.