Our users are building reports and some need weekends excluded from Lead Age. How can the users create a report formula that will count the Lead Age = 10 days and excludes weekends?
In the Object Manager, the formula for the Lead Age field = IF(IsConverted,ConvertedDate - DATEVALUE(CreatedDate), TODAY() - DATEVALUE(CreatedDate))
12 risposte
Then you can use only this part of formula:
(5 * ( FLOOR( ( TODAY() - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD(
TODAY() - DATE( 1900, 1, 8), 7 ) ) )
-
(5 * ( FLOOR( ( CreatedDate - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD(
CreatedDate - DATE( 1900, 1, 8), 7 ) ) )
