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. _
  • 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])


  • NoelleDivinagra's avatar
    NoelleDivinagra
    Qrew Trainee
    7 years ago
    Hello!

    I tried that formula but it gave me an error saying "Expecting duration"

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Do you really want it to be a formula duration field type?  I suggest making it a formula numeric field type and it will be the number of days in the pipeline.

     
  • NoelleDivinagra's avatar
    NoelleDivinagra
    Qrew Trainee
    7 years ago
    I got it! Thank you and to Chris for the help