Forum Discussion

NKH09's avatar
NKH09
Copper Contributor
Jan 09, 2024

DATEDIF If One Date is Blank

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? 

 

Resources