I inputted both my and my wife’s birth years (1960 and 1962). For 2023 it shows 64 and 62 and for 2024 it shows 65 and 63, etc. Not sure it impacts anything in the sheet, but I will turn 64 in 2024. How do I get this to display the proper ages, or does it not matter except for aesthetics?
It doesn’t really matter. It’s just a reference to map the values to something meaningful.
I believe the calculation is for the age you’ll be at the end of the year. If you want, you could just add or subtract one from the formulas in F25:G25.
I came here today wondering about this same issue because it is off by a year. I ended up taking @randy reply and adjusting the formulas in F25:G25 as follows: =IF(ISBLANK(C5),IFERROR(1/0),SEQUENCE(AS4,1,(AS3-C5)-1,1)); =IF(ISBLANK(C6),IFERROR(1/0),SEQUENCE(AS4,1,(AS3-C6)-1,1))
2 Likes
, 