Hi all,
I wonder if someone could help me with a formula using If, And & Or? I'm struggling a little bit. I've attached an example, but it's basically to give a status of whether an action is "Due" or "Overdue" or neither, dependent on the date and/or colour of cell:-
Red = a date in the past = "Overdue"
Yellow = a date in the next 30 days = "Due"
Green = a date more than 30 days in the future = ""
Thank you in advance.
Bookmarks