Reverse Networkdays??

[Drayton T.]

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.

 

[Mike H]

Hi

With your resolve by date in A1 try

=workday(A1,-15)

Format as date

Mike

 

[Drayton T.]

DOH!

Man..do I feel stupid.

thanks! D.

Hi

With your resolve by date in A1 try

=workday(A1,-15)

Format as date

Mike