function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ben Kingsley 8Ben Kingsley 8 

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

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

Thanks,
SalesFORCE_enFORCErSalesFORCE_enFORCEr
Check this 
https://success.salesforce.com/answers?id=90630000000gtmhAAA
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

Regards,
Parker