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
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
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI 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
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Perfect. Thank you !
------------------------------
Lynda Schutter
------------------------------