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. 


QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
See Chris's comment below. If the [Date in Pipeline] is just a date type field already, you do not have to try to make it a date field again.

try this

WeekDaySub (Today(),[Date in Pipeline])