Netdays - if blank

Cecily H

Hello all --

I have created a column to show me how many days between "today" and the expected close date of a sale. This is the formula I'm using:



=NETDAYS(TODAY(), Close Date16)

This is working, but I have one problem: I don't always have an expected close date. In those situations, I want the cell to display as blank. RIght now, if the close date column is blank, the net days column displays: #INVALID DATA TYPE. 

What do I need to add to my formula to fix this?

Thanks in advance for your help!

MarkLindsey

Hi Cecily,

Try this formula:

=IF(ISBLANK([Close Date]16), "", NETDAYS(TODAY(), [Close Date]16))

 

Cecily H

Success!! Thank you!