I need help with my current formula. Right now, it returns "OVERDUE" if a report is not presented in time. The issue is that I need the Overdue to not populate if a date is in the "Date report presented" field, even if it is past the due date or extension date. Below is my current formula:
[Will a report be prepared?]="yes" and
(IsNull([Date report presented])) and
(IsNull([Report Extension Due]) and Today() >[Report Due Date]) or (not IsNull([Report Extension Due]) and Today()> [report Extension Due]),
"<span style=\"color:#ff0707; font-weight:bold\">"&"OVERDUE"&"</span>"," "
// end if