Thread: Blank Cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
llutssirk llutssirk is offline
external usenet poster
 
Posts: 3
Default 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