DATEDIF If One Date is Blank

Copper Contributor

Hi-

 

I'm trying to create a project tracker and count the duration it takes from noted date (column F; data starting at F5) to completion date (Column J; Data starting J5) that connects to a live dashboard. How do I create a formula that prevents the "#NUM!" from showing up if the completion date column hasn't been filled out yet?Screenshot-DatedIF question.png 

 

1 Reply
=IF(J5="","",YourCurrentFormulaWithoutThe=Sign)