Networkdays - Tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I almost found my answer in the forum, but it seems I have a unique need for this function. I need to keep a record of how quickly estimates are returned to me from central purchasing. I will use the networkdays function. Column A will be the date they were submitted, column B will be the date they were returned. Colum C will be where the Networkdays function returns its results.

The Problem: I can not have Networkdays calculate a result in the rows where Column A is complete but Column B is empty. I have other cells calculating averages based on the result returned by the Networkdays function. I can not for the life of me figure out how to nest this function in an IF function. How can I get these results:

Example:
A1 B1 C1
12/1/03 12/5/03 5
12/1/03 -27112 <------------- I need this to go away.

Thanks for the help!!!

Matthew
 
I almost found my answer in the forum, but it seems I have a unique need for this function. I need to keep a record of how quickly estimates are returned to me from central purchasing. I will use the networkdays function. Column A will be the date they were submitted, column B will be the date they were returned. Colum C will be where the Networkdays function returns its results.

The Problem: I can not have Networkdays calculate a result in the rows where Column A is complete but Column B is empty. I have other cells calculating averages based on the result returned by the Networkdays function. I can not for the life of me figure out how to nest this function in an IF function. How can I get these results:

Example:
A1 B1 C1
12/1/03 12/5/03 5
12/1/03 -27112 <------------- I need this to go away.

Thanks for the help!!!
Click to expand...


=IF(B1=0,"",NETWORKDAYS(A1,B1))


--ron
 
Back
Top