Forum Discussion
NKH09
Jan 09, 2024Copper Contributor
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?
1 Reply
Sort By
- JKPieterseSilver Contributor=IF(J5="","",YourCurrentFormulaWithoutThe=Sign)