Skip to main content
Question

Calculate total number of days between today and [Date in Pipeline] excluding weekends.

Hello! I need help on this.

Calculate total number of days between Today and [Date in Pipeline] excluding weekends. 

I have the below formula, but I get an error message saying "Expecting text/datetime/workdate but found date"

WeekdaySub (Today(),ToDate([Date in Pipeline]))
    This topic has been closed for replies.

    Is your formula field a numeric data type? I believe WeekDaySub yields a numeric value. 


    You may have also wrapped ToDATE() around a regular date field. You don't need to do that. 
    Terms & ConditionsAccessibility statement