Forum Discussion

NoelleDivinagra's avatar
NoelleDivinagra
Qrew Trainee
7 years ago

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/d...
Errors
Formulas and functions
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
7 years ago
Is your formula field a numeric data type? I believe WeekDaySub yields a numeric value. 


NoelleDivinagra's avatar
NoelleDivinagra
Qrew Trainee
7 years ago
I have a Duration field type. I also have this formula Today() - [Date in Pipeline] but it doesn't exclude weekends. _