function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ben Kingsley 8Ben Kingsley 8 

Calculate the Number of Days between today and Expiration Date excluding weekends

I need help calculating the number of days between Today and Expiration_Date__c for a formula field.  Can someone please help.

Check this
Ben Kingsley 8Ben Kingsley 8
I tried this however I need to replace Start Date with Today and salesforce doesn't like it.  
Parker EdelmannParker Edelmann
I assume then that Expiration_Date__c is a Date/Time field instead of a Date field. If that's the case, this should work:
TODAY() - DATEVALUE(Expiration_Date__c)
If Expiration_Date__c is just a date field, then try this:
TODAY() - Expiration_Date__c