Blank Cell
 

I have a work sheet that contains multiple columns, three that contain date
information. The first column(G) is named Date Assigned; the second column(H)
is named Date Completed; the third column(I) is named Days Taken to Complete.
(I) should be net work days. I have used the NETWORKDAY function, but when,
lets say cell H1 is blank because the assignment is not complete, cell I1,
which contains the formula, will return a large negative number. I would
like that cell to remain blank until a date in entered in cell H1. And, if
possible, I would like to have text "days" to appear after the number that
results in cell I1.

Thanks

Blank Cell
 

Try this

=IF(H2="","",NETWORKDAYS(G2,H2))

Mike

"llutssirk" wrote:

I have a work sheet that contains multiple columns, three that contain date
information. The first column(G) is named Date Assigned; the second column(H)
is named Date Completed; the third column(I) is named Days Taken to Complete.
(I) should be net work days. I have used the NETWORKDAY function, but when,
lets say cell H1 is blank because the assignment is not complete, cell I1,
which contains the formula, will return a large negative number. I would
like that cell to remain blank until a date in entered in cell H1. And, if
possible, I would like to have text "days" to appear after the number that
results in cell I1.

Thanks

Blank Cell
 

Thanks Mike,

I have that formula in the cell, and it works when the cell is blank. However
it returns #NAME? when a date is placed in H2. I have the date fromat set at
custom m/d/yy in one cell and the default *8/20/2008 in another to test the
date format. the formula still returns #NAME? when the cell contains a date.
Is the date format the problem?

Kris

Mike H wrote:
Try this

=IF(H2="","",NETWORKDAYS(G2,H2))

Mike

I have a work sheet that contains multiple columns, three that contain date
information. The first column(G) is named Date Assigned; the second column(H)
[quoted text clipped - 7 lines]

Thanks

Blank Cell
 

Hi,

Tools|Addins
Select the analysis toolpak
Select your cell, tap f2 then enter

Mike

"llutssirk" wrote:

Thanks Mike,

I have that formula in the cell, and it works when the cell is blank. However
it returns #NAME? when a date is placed in H2. I have the date fromat set at
custom m/d/yy in one cell and the default *8/20/2008 in another to test the
date format. the formula still returns #NAME? when the cell contains a date.
Is the date format the problem?

Kris

Mike H wrote:
Try this

=IF(H2="","",NETWORKDAYS(G2,H2))

Mike

I have a work sheet that contains multiple columns, three that contain date
information. The first column(G) is named Date Assigned; the second column(H)
[quoted text clipped - 7 lines]

Thanks

Blank Cell
 

Excellent help. Thanks Mike for your time and for passing along experienced
usage.

Thanks again...

Mike H wrote:
Hi,

Tools|Addins
Select the analysis toolpak
Select your cell, tap f2 then enter

Mike

Thanks Mike,

[quoted text clipped - 17 lines]

Thanks

Blank Cell
 

It was good of Mike to have helped, but please remember that typing the word
NETWORKDAYS into Excel help would have given you the answer. It's always
worth trying there first.
--
David Biddulph

"llutssirk" <u45601@uwe wrote in message news:88f5bc6ad0fc1@uwe...
Excellent help. Thanks Mike for your time and for passing along
experienced
usage.

Thanks again...

Mike H wrote:
Hi,

Tools|Addins
Select the analysis toolpak
Select your cell, tap f2 then enter

Mike

Thanks Mike,

[quoted text clipped - 17 lines]

Thanks