I want to create a formula field that will calculate a value based on how much time has passed from a date field.
Example. I want the formula to evaluate to 1 if date is one year from my , 2 if it is 2 years ahead of closed date .... etc. It doesn't matter if the field is text or number. How do I do this?