How can this formula that calculates working days from ANYDATEFIELD to TODAY() be adjusted to Zoho CRM formula functions?
CASE(MOD( ANYDATEFIELD - DATE(1985,6,24),7),
0 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,3,4,4,5,4,6,4,0),
1 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,3,4,3,5,3,6,4,0),
2 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,2,4,2,5,3,6,4,0),
3 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,1,3,1,4,2,5,3,6,4,0),
4 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,0,2,0,3,1,4,2,5,3,6,4,0),
5 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,0,2,0,3,1,4,2,5,3,6,4,0),
6 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,0,2,1,3,2,4,3,5,4,6,4,0),
777)
+
(FLOOR(( TODAY() - ANYDATEFIELD )/7)*5)
In case it is impossible, is there a formula that can be used to calculate the amount of working days from ANYDATEFIELD up TODAY()?