Autofill Series into a specific number of rows

Dear all,

I am trying to figure out a way to fill a specific number of rows within 1 column with a series of data contingent on another variable.

specifically I am looking to auto fill a row with each year from "Today" to the year in which a person turns 100. I have a cell where a person would put in their DOB and based off of that the column would fill with years now to the age 100. For example DOB 01/01/1950 entered in Cell B2. In Column C beginning in cell C2 I would like the sheet to autofill from 2017 to 2050 (when the person turns 100). I would like for the cells after the cell reading 2050 in Column C to be blank rather than read "False."

Thank you all so much.

Put this formula in C2:

=IF(B2="","",YEAR(TODAY()))

and this one in C3:

=IF(C2="","",IF(C2+1>YEAR($B$2)+100,"",C2+1))

Copy the formula in C3 down as far as you like.

Hope this helps.

Pete