function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
kamal3883kamal3883 

Calculate case age in business days

Hi,

 

I want to implement case age using formula field. my requirement is like this.

 

1) Only weekdays are business days.

 

2) i also want to use business hours. suppose if business hour is 8am to 8 pm.  so after 10 days it should say 120 not 240 hours.

Forza di SognoForza di Sogno

What have you tried so far?  Can you post your formula?

Forza di SognoForza di Sogno

You might be able to take care of this in a formula field - see this blog.

kamal3883kamal3883

CASE(MOD( datevalue(CreatedDate)- DATE(1985,6,24),7), 

0 , CASE( MOD( ClosedDate - CreatedDate,7),1,2,2,3,3,4,4,5,5,5,6,5,1), 
1 , CASE( MOD( ClosedDate - CreatedDate ,7),1,2,2,3,3,4,4,4,5,4,6,5,1), 
2 , CASE( MOD( ClosedDate - CreatedDate,7),1,2,2,3,3,3,4,3,5,4,6,5,1), 
3 , CASE( MOD( ClosedDate - CreatedDate,7),1,2,2,2,3,2,4,3,5,4,6,5,1), 
4 , CASE( MOD( ClosedDate - CreatedDate,7),1,1,2,1,3,2,4,3,5,4,6,5,1), 
5 , CASE( MOD( ClosedDate - CreatedDate,7),1,0,2,1,3,2,4,3,5,4,6,5,0), 
6 , CASE( MOD( ClosedDate - CreatedDate,7),1,1,2,2,3,3,4,4,5,5,6,5,0), 
999) 

(FLOOR(( ClosedDate - CreatedDate)/7)*5)

 

it only calculates based on weedays....

kamal3883kamal3883

Anyone any update