Formula to calculate weekdays
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 ...
Forum Discussion
Try this
Total days on orientation:
If(
[Process Status]="Completed",WeekDaySub([
WeekDaySub(Today(),[Effective Date]))
Total Days Overdue:
WeekDaySub(Today(),[OVT Due Date])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Total days on orientation:
If(
[Process Status]="Completed",WeekDaySub([
WeekDaySub(Today(),[Effective Date]))
Total Days Overdue:
WeekDaySub(Today(),[OVT Due Date])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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
------------------------------
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
------------------------------
- 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
------------------------------- Perfect. Thank you !
------------------------------
Lynda Schutter
------------------------------
