Hello
I would appreciate you help with this
A1 = Balance Due £
B1 = Balance Due Date
I am trying to get C1 to read "7 DAYS" , if A1 is greater than 0 and B1 falls within the next 7 days, or to read "OVERDUE" , if A1 is greater than 0 and B2 is less than today.
Many Thanks
Bill S
I would appreciate you help with this
A1 = Balance Due £
B1 = Balance Due Date
I am trying to get C1 to read "7 DAYS" , if A1 is greater than 0 and B1 falls within the next 7 days, or to read "OVERDUE" , if A1 is greater than 0 and B2 is less than today.
Many Thanks
Bill S