• 0
• Question
• Updated 3 years ago

I need assistance creating a formula to calculate an on going lead time. Details are it needs to count number of current working days and then once another field is updated show a total working days. I can do this use two separate fields but want to combine it into one field so it easier to report on.

a) Number of working days between 'Request Date' and the current date.

b) Then once a field 'Report Sent' is updated with a date, the field to display the final number of working days between 'Request Date' and 'Report Sent'.

Apologies, I have tried to explain the requirement as best as possible. Thank you for any assistance.

• 0 Points

Posted 3 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 67,780 Points
No problem, your explanation was lucid.

Try this as a formula numeric field called Lead Time Days

IF(not Isnull([Report Sent]),ToDays([Report Sent] - [Request Date]), ToDays(Today() - [Request Date]))
• 0 Points
Thank you that formula works but it currently is counting all the days in a calendar week - ToDays. What is the right function to use so it just counts Weekdays (Mon - Fri)?

QuickBaseCoach App Dev./Training, Champion

• 67,780 Points
IF(not Isnull([Report Sent]),

WeekDaySub([Report Sent], [Request Date]), WeekDaySub(Today(), [Request Date]))