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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Logical function 5
VBA - exporting serial letters to single documents 0
Adding cells until they are greater than a lookup cell and returning a value 1
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Use TODAY() function as the criteria in a SUMIF formula 1
VLookup IF word in string exists within cell, use the word. 0
If formula producing #VALUE Error 2
countifs Function not giving desired result with date criteria 2

Top