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
|