Blank Cell

[llutssirk]

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

 

[Mike H]

Try this

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

Mike

 

[llutssirk]

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

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

 

[Mike H]

Hi,

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

Mike

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

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

 

[llutssirk]

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

Thanks again...

Hi,

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

Mike

Thanks Mike,

[quoted text clipped - 17 lines]

 

[David Biddulph]

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

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

Thanks again...

Hi,

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

Mike

Thanks Mike,

[quoted text clipped - 17 lines]

Thanks