+ 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