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
Check out the Formula Handbook template!