Skip to main content
Question

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

  • Aug 22, 2018 11:34 PM UTC
  • 0 replies
  • 215 views

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.

  • Qrew Corporal
  • Aug 22, 2018 11:55 PM UTC
Is your formula field a numeric data type? I believe WeekDaySub yields a numeric value. 



  • Qrew Corporal
  • Aug 22, 2018 11:58 PM UTC
You may have also wrapped ToDATE() around a regular date field. You don't need to do that.