Hello All, I am working with a spreadsheet that contains a Field called
"Resolve by Date" This date is computed in the application that is supplying
the raw data. What I am trying to do is this: Use the "Resolve by Date" to
determine the date that the request was submitted. I know that this "Resolve
by Date" is 15 networkdays from the date the request was submitted. How do I
back into this "Submit" date using the networkdays function? It appears
simple, but the answer is escaping me! Any guidance would be greatly
appreciated. D.

Hi

With your resolve by date in A1 try

=workday(A1,-15)

Format as date

Mike

"Drayton T." wrote:

Hello All, I am working with a spreadsheet that contains a Field called
"Resolve by Date" This date is computed in the application that is supplying
the raw data. What I am trying to do is this: Use the "Resolve by Date" to
determine the date that the request was submitted. I know that this "Resolve
by Date" is 15 networkdays from the date the request was submitted. How do I
back into this "Submit" date using the networkdays function? It appears
simple, but the answer is escaping me! Any guidance would be greatly
appreciated. D.

DOH!

Man..do I feel stupid.

thanks! D.

"Mike H" wrote:

Hi

With your resolve by date in A1 try

=workday(A1,-15)

Format as date

Mike

"Drayton T." wrote:

Hello All, I am working with a spreadsheet that contains a Field called
"Resolve by Date" This date is computed in the application that is supplying
the raw data. What I am trying to do is this: Use the "Resolve by Date" to
determine the date that the request was submitted. I know that this "Resolve
by Date" is 15 networkdays from the date the request was submitted. How do I
back into this "Submit" date using the networkdays function? It appears
simple, but the answer is escaping me! Any guidance would be greatly
appreciated. D.