Trying to create a formula in AX4 that has the following criteria:
- Returns "Y" if Today's Date falls between the date noted in AV and the date noted in AW and AT is "NO";
- "N" if Today's Date falls past the date noted in AW and AT is "NO";
- "NA" if AT is a "YES";
- and BLANK if nothing is entered in AQ