Past Due Dates

[abruce]

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"""),"")

 

[FormR]

Hi, welcome to the board

Building on your existing formula, maybe:

=IF(COUNT(B1,A1)=2,TEXT(A1-B1,"0 ""Day(s) Late"";0 "" Day(s) Early"";""On Time"""),TEXT(TODAY()-A1,"0 ""Days(s) overdue"";;"))

 

[abruce]

Hi

Perfect!!! thank you so much!!