Nesting IF statements, involving dates

[dasbear3]

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

I have yet to nest multiple IF statements, and would appreciate a point in the right direction! Thank you for your time.

 

[mvptomlinson]

Perhaps:

=IF(AQ4="","",IF(AT4="YES","NA",IF(AT4="NO",IF(AND(TODAY()>=AV4,TODAY()<=AW4),"Y",IF(TODAY()>AW4,"N","")))))

 

[dasbear3]

This is PERFECT! Thank you very much!!