+ Start a Discussion
TheresaAndersonTheresaAnderson 

Calculate Lead Age

Does anyone have a formula to calculate the Lead Age (creation date - conversion date)?  We are measuring the age of our Lead process.

 

Thank you.

Best Answer chosen by Admin (Salesforce Developers) 
Steve MolisSteve Molis

Here you go:

IF(IsConverted,ConvertedDate - DATEVALUE(CreatedDate), TODAY() - DATEVALUE(CreatedDate))

 

PS.  You owe me a beer! (these terms are non-negotiable)

All Answers

Steve MolisSteve Molis

Here you go:

IF(IsConverted,ConvertedDate - DATEVALUE(CreatedDate), TODAY() - DATEVALUE(CreatedDate))

 

PS.  You owe me a beer! (these terms are non-negotiable)

This was selected as the best answer
TheresaAndersonTheresaAnderson

Thank you!!!!

Steve MolisSteve Molis

No problem, I like to drink these ->  http://beeradvocate.com/beer/profile/863/7971

Sales Rapt MediaSales Rapt Media
This is great! Do you implement this forumla in a contact report, lead report or opportunity report?
Danielle DeBenedictisDanielle DeBenedictis
This isn't working for me.... it keeps telling me that the field 'Converted' does not exist. Any ideas??? Does anyone know what 'DB Lead Age' means? It doesn't seem to mean converted minus create date... 
JPSeaburyJPSeabury
Dainelle -- the field name isn't "Converted", it's "IsConverted". Copy and paste the formula string exactly as Steve wrote it -- and don't forget his beer. :-)