IF statement with a date

  • Thread starter Thread starter Ed
  • Start date Start 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)
 
one way:

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

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