TODAY()- DATEVALUE(CreatedDate)
I want to be able to remove weekends from the count. I am not worried about holidays, but would like to remove weekends if possible.
Thank you for your time and assistance as always.
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
First, don't use ISNULL, it's been deprecated a long time ago, use ISBLANK instead.
Second, you need to replace TODAY() with Contract_Review_Date__c in the second part of the formula:
IF( ISBLANK( Contract_Review_Date__c ) , TODAY()- DATEVALUE(CreatedDate) - ( FLOOR((TODAY()- DATEVALUE(CreatedDate))/7)*2 + IF(AND(WEEKDAY(DATEVALUE(CreatedDate) )=1, WEEKDAY(TODAY() )<>7),1, IF(CASE(WEEKDAY(DATEVALUE(CreatedDate) ),1,8,WEEKDAY(DATEVALUE(CreatedDate) ))>CASE(WEEKDAY(TODAY() ),1,8,WEEKDAY(TODAY() )),2, IF(OR (WEEKDAY(TODAY())=7, WEEKDAY(DATEVALUE(CreatedDate) )=1),1, IF(OR (WEEKDAY(TODAY())=1, WEEKDAY(DATEVALUE(CreatedDate) )=7),2, 0))))), Contract_Review_Date__c- DATEVALUE(CreatedDate) - ( FLOOR((Contract_Review_Date__c- DATEVALUE(CreatedDate))/7)*2 + IF(AND(WEEKDAY(DATEVALUE(CreatedDate) )=1, WEEKDAY(Contract_Review_Date__c )<>7),1, IF(CASE(WEEKDAY(DATEVALUE(CreatedDate) ),1,8,WEEKDAY(DATEVALUE(CreatedDate) ))>CASE(WEEKDAY(Contract_Review_Date__c ),1,8,WEEKDAY(Contract_Review_Date__c )),2, IF(OR (WEEKDAY(Contract_Review_Date__c)=7, WEEKDAY(DATEVALUE(CreatedDate) )=1),1, IF(OR (WEEKDAY(Contract_Review_Date__c)=1, WEEKDAY(DATEVALUE(CreatedDate) )=7),2, 0))))))
