=INT((TODAY()-A2)/365)+1
It's not clear whether you want to include today and/or the date in question
in your count of 365, so you may want to experiment with a +1 or -1 between
the A2 and the immediately following closing parenthesis.
--
David Biddulph

"Matt" wrote in message
...
Can some one help me with the following formula?

I need to create a IF formula that will start with the current date
"=TODAY"
and count backwards appling a different numeric number for each year.
ie. from today back 365 days=1; from 366 to 730=2; from 730 to 1095=3;
from
1095 on =4.