I'm trying to create a formula that states a task is overdue. I have it working properly for one statement, but can't get it right if I add another condition. I need it to state a filing is overdue if the day is past today, unless the filing is on extension, then I need it to use the extension due date to calculate. I have a date return filed, a due date, extension due date and a checkbox if the return is on extension. Below is I'm original formula, but it doesn't work if the return is on extension.
If(IsNull([Date Return Filed]) and ((Today() >[Due Date]) or (Today()> [Extension Due])), "<span style=\"color:#ff0707; font-weight:bold\">"&"OVERDUE"&"</span>" )
Thoughts? Thank you.