I’m working on a spreadsheet which has expected dates (A1) & actual dates (B1)
I need a formula which shows me what arrived on time, what was late & by how many days, what was early by how many days, & what is over due and by how many days
A1 = Expected date
B1 = Actual date
I have managed to work out part of the formula which shows if it was on time, late or early, but I can’t work out if “B1” is blank show to show it's overdue and by how many days
=IF(COUNT(B1,A1)=2,TEXT(A1-B1,"0 ""Day(s) Late"";0 "" Day(s) Early"";""On Time"""),"")
I need a formula which shows me what arrived on time, what was late & by how many days, what was early by how many days, & what is over due and by how many days
A1 = Expected date
B1 = Actual date
I have managed to work out part of the formula which shows if it was on time, late or early, but I can’t work out if “B1” is blank show to show it's overdue and by how many days
=IF(COUNT(B1,A1)=2,TEXT(A1-B1,"0 ""Day(s) Late"";0 "" Day(s) Early"";""On Time"""),"")