Thank you in advance for any help you may be able to provide.
I need to track how many days between “Date Received” and completion of certain tasks (i.e. "Date Assessment Completed", "Date Report Submitted/Completed", "If in Progress Running Days Count").
For example - I can get it to show me how many days between “Date Received” and “Date Assessment Completed” by using the following:
=IF([Date Received]@row ="", "", IF([Date Assessment Completed]@row ="", NETDAYS([Date Received]@row , TODAY()), NETDAYS([Date Received]@row , [Date Assessment Completed]@row )))
And between the “Date Received” and “Date Report Completed/Submitted by using the following:
=IF([Date Received]@row ="", "", IF([Date Report Completed/Submitted]@row ="", NETDAYS([Date Received]@row , TODAY()), NETDAYS([Date Received]@row , [Date Report Completed/Submitted]@row )))
However, if no date has been entered, it still shows a running count of the days. Is there a way to not show a total days in the “# of Days…” cell UNTIL an actual date has been entered in the “Date Assessment Completed” or “Date Report Completed/Submitted” field has been entered?
Also, I would like to track how many days have elapsed from “Date Received” IF the referral is still open and no date has been entered for the “Date Assessment Completed” or the Date Report Completed/Submitted”.
And finally, is there a way to lock the columns so that no one can change the data in them. Example, I do not want anyone to be able to change the last three columns that track the number of days between received and completed or in progress.
