Formula help needed using Year

Question

Formula help needed using Year

I am developing a Client Assessment Form for my use. In one cell, I input the individual's birthdate in the YYYY-MM-DD format. Next, I want just the Year, showing up in a different cell - I just copied the input cell, and set it to just show the year.

Next, I want the Table to calculate the next 21 years, so if I am starting out 1970, the cell under would be 1971, cell under that 1972, and so forth. I tried +1, and that doesn't work. It just repeats the 1970. I realize I could just re-type in the 1970 and that calculation would work, but I am trying to streamline the process.

Thanks in advance for any help.

iMac (27-inch, Late 2012), iOS 9.0.2

Posted on Oct 2, 2015 5:15 PM

Reply

Answer 1

Best reply

Badunit

Level 7

25,802 points

Oct 2, 2015 5:32 PM in response to BAM from Bethel Park

if Cell A2 is the birthdate, YEAR(A2) will give you the year as a number.

cell B2 = YEAR(A2)

cell B3 = B2+1

fill down from B3 until you have the 21 years.

The way you were doing it, you still had a full date in the "year" cell. Adding 1 to a date increases the day by 1, not the year.

Reply

Answer 2

Oct 2, 2015 5:34 PM in response to Badunit

Thanks so much, I really appreciate your taking the time to answer and explain. I have it working correctly now!

I was at the Apple store last night, and two of the employees there told me it couldn't be done.

Reply