IF statement with a date

E

Ed

I want to write a IF statement where the logical test determines if the cell
value if greater that a certain date.
The cell is formatted in date format. Not sure how to write the date.

T.I.A.
Ed


If(Y2>DATE,TRUE,FALSE)
 
J

JE McGimpsey

one way:

=(Y2 > DATE(2004,03,1)

Will return TRUE if Y2 is greater that 1 March 2004.
 
Top