Skip to main content
Question

Formula to calculate weekdays

  • January 25, 2023
  • 0 replies
  • 356 views
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement