How to calculate date from submit date

Good morning,

I am trying to calculate the number of workdays that an inquiry has been pending since the date submitted.  I currently used the following formula =NETWORKDAY([Modified Date/Time]1, [Submitted Date]1) * -1 but then I realized that if an user has not modified the inquiry on daily basis, I will not get a true pending total. I have tried the following:

=networkdays([Submitted Date]2@row, Today()) but received an error message #UNPARSEABLE

Best Answer

Answers