Hi all

I have a range of values from 1 to 1800

I want a formula that sayd if the values is between 1-180 then OK, 180-365 is 1 Year, 366-730 then 2 years etc etc

Cant get it too work

help appreciated

thanks