I am trying to figure out how to make my simple formula (=TODAY()-I2) return a year, i.e. if the days are 0-365 it would return a 1, 366-730 it would return 2, etc. Any help would be greatly appreciate...I am fairly well lost in most excel functions

If TODAY()-I2 is positive then

=CEILING((TODAY()-I1)/365,1)

Thanks for the help, I have two follow up questions, did your formula mean to say I2, not I1? also, how would I continue the number for each consecutive year? These will end up going out to a 5 year range.

Thanks

WooHoo, forget my follow up questions, your formula worked perfectly and as written it automatically determined the correct cycle.

Thank you for sharing your expertise.

Yes, I should have written I2 instead of I1 in the formula.