DATEDIF If One Date is Blank

Copper Contributor



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