IF statement, involving dates

[dasbear3]

I'm attempting to create a formula using dates where the outcome is determined on data within a cell..

If the date within cell AF4 (and all cells within that column) takes place before 01/01/1987, "C" needs to populate in AG4. On 01/01/1987 and after, "F" should populate in cell AG4.

I attempted to use this formula, but to no avail:
=IF(AND(AF4>01/01/1987,AF4<01/01/1987)F,C)

• Would it matter if the data in AF4 is blank?
• Does this make a difference if the date is formatted as mm/dd/yy, mm/dd/yyyy.. etc?

Please advise if there's a step I'm missing, or just going about it the wrong way. Thank you!!

 

[phxsportz]

=IF(AND(AF4>DATEVALUE("01/01/1987"),AF4 < DATEVALUE("01/01/1987")),"F","C")<DATEVALUE("01 p 1987?)),?f?,?c?)< 01>

 

[dasbear3]

I was able to use this formula to get the data to populate:

=IF(AF4>DATEVALUE("01/01/1987"),"F","C")

However, if AF4 is blank, it still shows up with "C". I tried attaching an =ISBLANK(AF4),", to the beginning but there's an error. Any thoughts?

 

[lenze]

Try

=IF(AF4,IF(AF4>DATEVALUE("01/01/1987"),"F","C"),"")

lenze

 

[drsarao]

I was able to use this formula to get the data to populate:

=IF(AF4>DATEVALUE("01/01/1987"),"F","C")

However, if AF4 is blank, it still shows up with "C". I tried attaching an =ISBLANK(AF4),", to the beginning but there's an error. Any thoughts?

Try:
=IF(AF4="","",IF(AF4>=DATEVALUE("01/01/1987"),"F","C"))

 

[dasbear3]

A big THANK YOU to lenze and drsarao.. BOTH formulas worked!