Duration for Workdays
I need to create a report that reflects the number of Work Days early or late for a project. I have a report now that gives me calendar days based upon the Todays function using Start Date and a Compl...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this format as a formula numeric field.
WeekdaySub([End Date], Start Date])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
WeekdaySub([End Date], Start Date])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Thank you for the quick response and that gave me my first answer. Is there a way I can utilize the WeekdaySub to generate a running number when overdue? Current formula looks like this
If([Status] = "Completed", null, ToDays(Today() - [Task Due Date])<=0, null, ToDays(Today() - [Task Due Date]))
I tried just changing the ToDays to WeekdaySub and that was not the answer.
------------------------------
Jeff Jeff
------------------------------
If([Status] = "Completed", null, ToDays(Today() - [Task Due Date])<=0, null, ToDays(Today() - [Task Due Date]))
I tried just changing the ToDays to WeekdaySub and that was not the answer.
------------------------------
Jeff Jeff
------------------------------
- MarkShnier__YouPlease say in regular words what you want the formula to do and I will help you with the syntax.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- I need it to have a running tally of days overdue based upon the due date in workdays until the job is complete.
------------------------------
Jeff Jeff
------------------------------- MarkShnier__YouNot tested by try this
IF([Status]<>"Completed" and Today() >[Task Due Date], WeekdaySub(Today(),[Task Due Date]))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
