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.