+ Start a Discussion
Ajay Kumar 583Ajay Kumar 583 

Need To create a Formula On Opportunity.

Hi Team,

Need a formula on Opportunity to show number of days since Opportunity is opened. 
For Ex: If Opportunity is created on 1st July, formula field will show “10 days” as of 10th July.
Use Created Date field. Do not show any date if Opportunity is “Closed Won” or “Closed Lost”.
In that case it would show “-1 day”.
Best Answer chosen by Ajay Kumar 583
Ajay K DubediAjay K Dubedi
Hi Ajay,

Create a formula field with number type and use below formula:-

IF( ISPICKVAL(StageName, "Closed Won")  ||  ISPICKVAL(StageName, "Closed Lost") , -1,  TODAY() -  DATEVALUE(CreatedDate) )

It will return no. of days counted from created date.

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi