You need to sign in to do that
Don't have an account?
kamal3883
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.
What have you tried so far? Can you post your formula?
You might be able to take care of this in a formula field - see this blog.
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....
Anyone any update