Late application formula
Hi- I have 3 date fields that I would like to compare to determine if an application is late (app status):
final filing date
extended filing date
app status ( late )
if app is submitted on 1/15/21 and the final filing date is 1/15/21 the app status should be BLANK; if there is an extended filing date of 1/20/21 the app status field should still be blank; if the app is received 1/16/21 the app status should be blank (as the filing date was extended).
If there is no extended filing date and the final filing date is 1/15/21 and app is received on 1/16/21 the app status should say LATE; if there is an extended filing date of 1/21 and an app is received 1/22/21 app status would be LATE - so the app status field needs to first determine if there is an extended date - if not, calc the app sub date against the final filing date; if there is an extended filing date, the app status should calc the app sub date against the extended filing date.
I have had this working but it does not stick ... it will note remove a LATE from the column if I make changes... also it is regarding the app sub date and the ffd or effd as = when I use (i.e., app sub 1/5/21, ffd 1/5/21 should not be LATE - thank you
Help Article Resources
Check out the Formula Handbook template!