IF Statement - Compare Dates or Leave Blank

I'm working on tracking a on time delivery metric that will show 0% or 100% based on if a delivery is inside 5 days of the commit. I'm getting stuck with the formula leaving the cell blank if the receipt date is blank.

Column A - Need By Date

Column B - Commit Date

Column C - Actual Receipt Date

Formula needs to output the following; Find delta between Column C and Column A, leave blank if Column C is blank.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!