I need to Calculates days between current day and "Lead Open Date". It should stop counting when Lead Status no longer = "Open". How can i achieve this.Please suggest as i am not able to identify the solution
I created a workflow rule which is set the date when status change to Open then i created one formula field which is counting the days .but when i change the status from open then it formula field set o. My requirement is when status change to' Open' it will start counting days in duration field when i change the status to other then the duration remain the same and if again I change the status to Open from other status then it should start counting again from start.
My formula field