Calculating Days - Error if no date is entered

Miki Klemesrud

I have a column called "Closing Date".  I also have a column that calculates the number of days until the closing date.  It works great if I have entered the closing date.  However, if we don't know the closing date yet and leave that column blank I then get an error in the column that is calculating the closing date.  Anyway to just have it be blank?

 

Here is the formula I am using:  =NETDAYS(Today2, [Close Date]2)

 

Here is the error I am getting when no date is entered in the Close Date column:  

#INVALID DATA TYPE

 

Thanks for your help.

 

J. Craig Williams

Lots of ways to fix that. 

Here's one:

 

=IFERROR(NETDAYS(Today2, [Close Date]2), "")

 

You can also avoid using the [Today] column like this

 

=IFERROR(NETDAYS(TODAY(), [Close Date]3), "")

 

Hope this helps

 

Craig

Miki Klemesrud

Thank you Craig, I was able to remove the today and use the formula you gave me.  Worked perfect.  Thank you.

J. Craig Williams

You are welcome.

Craig