Discussions

 View Only
  • 1.  Formula to calculate weekdays

    Posted 01-25-2023 12:02
    I am trying to figure out total  "Days on Orientation and "Days Overdue".  My current formulas are able to give me the total days, and not business days. What do I need to add to the below formula to count only business days?

    Total days on orientation:
    If([Process Status]="Completed",([Orientation Completed]-[Effective Date]),Today()-[Effective Date])

    Total Days Overdue:
    Today()-[OVT Due Date]

    ------------------------------
    Lynda Schutter
    ------------------------------


  • 2.  RE: Formula to calculate weekdays

    Posted 01-25-2023 12:08
    Edited by Mark Shnier (Your Quickbase Coach) 01-25-2023 12:10
    Try this

    Total days on orientation:
    If(
    [Process Status]="Completed",WeekDaySub([
    Orientation Completed], [Effective Date]),
    WeekDaySub(Today(),[Effective Date]))


    Total Days Overdue:
    WeekDaySub(Today(),[OVT Due Date])



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Formula to calculate weekdays

    Posted 01-25-2023 12:27
    Thank you so much for the quick response!
    in the first formula I get an error message  "expecting duration but found number"

    My Orientation Complete and Effective Date are both date field types and my field to display the numbers are Duration-Formula.

    Should those be something else?

    ------------------------------
    Lynda Schutter
    ------------------------------



  • 4.  RE: Formula to calculate weekdays

    Posted 01-25-2023 12:31
    I suggest that you change the field type to formula numeric.  The is no need for the extra complexity of a duration field type when you are really just counting the integer number of days.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Formula to calculate weekdays

    Posted 01-25-2023 13:36
    Perfect.  Thank you !

    ------------------------------
    Lynda Schutter
    ------------------------------