Hello,
I saw similar posts but nothing seemed to work for what I am needing. I am attempting to divide by the amount of weekdays within the last 30 days. I want the formula to know how many of the last 30 days were week days versus weekends and then divide by that interval.
Is this possible? Below is my current formula which is giving me an interval of 35 weekdays ?!?
((5 * ( FLOOR( ( TODAY() - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( TODAY() - DATE( 1900, 1, 8), 7 ) ) )
-
(5 * ( FLOOR( ( (TODAY()-30) - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( (TODAY()-30) - DATE( 1900, 1, 8), 7 ) ) ))
btw - This Formula is returning the number 21 for me (not 35)
(5 * ( FLOOR( ( TODAY() - DATE( 1900, 1, 8) ) / 7 ) )
+
MIN( 5, MOD( TODAY() - DATE( 1900, 1, 8), 7 ) ) )
-
(5 * ( FLOOR( ( (TODAY() - 30) - DATE( 1900, 1, 8) ) / 7 ) )
+
MIN( 5, MOD( (TODAY() - 30) - DATE( 1900, 1, 8), 7 ) ) )
