Blank cell when a corresponding cell left empty

[excelbeginner2]

Hi all, I'm sure this is incredible simple for someone in the know but as I'm still a beginner I'm in need of some help

I have recently collected a sheet to measure how long my team are taking to send out free samples to our customers. In Column G is the date the request for a sample was received from a customer. Once the sample has been sent my colleagues will enter a date in Column I.

At the moment I am using a simple =networkdays(G2,I2) formula.

Where the I column date/value has not yet been entered I would like the "total lead days" cell to remain blank until such a time when the item is complete.

Thanks in advance!

 

[Rick Rothstein]

Hi all, I'm sure this is incredible simple for someone in the know but as I'm still a beginner I'm in need of some help

I have recently collected a sheet to measure how long my team are taking to send out free samples to our customers. In Column G is the date the request for a sample was received from a customer. Once the sample has been sent my colleagues will enter a date in Column I.

At the moment I am using a simple =networkdays(G2,I2) formula.

Where the I column date/value has not yet been entered I would like the "total lead days" cell to remain blank until such a time when the item is complete.

If I understand correctly, I think you are looking for this...

=IFERROR(NETWORKDAYS(G2,I2),"")

 

[excelbeginner2]

Perfect! Thanks!!!