I've been asked to create a field that will show the age of a lead so that stagnant leads can easily be identified. I've got a basic formula however it's not exactly what I want. I want the formula to calculate the age of a lead until it's converted or today if it has not yet been converted and is not equal to particular lead stages.
Currently I'm using a "Last Call Date" field but would really prefer the ability to pull in a converted date if possible and use that instead of the Last Call Date which is a date I've opted to use instead.
This is what I have, suggestions would be appreciated.
I am not a programmer and come from a Salesforce.com background where formulas "appear" to be much easier to create to accomplish this feat.