# Discussions

View Only

## Formula to calculate weekdays

• #### 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@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.

------------------------------