You're welcome!

--
Biff
Microsoft Excel MVP


"pat67" wrote in message
...
On May 21, 2:04 pm, "T. Valko" wrote:
=IF(J2<6/1/2010,"N/A",J2)

Excel evaluates that as: IF J2 is less than 6 divided by 1 divided by
2010.

The best way to do this is to use a cell to hold the date:

A1 = 6/1/2010

Then just refer to that cell:

=IF(J2<A1,"N/A",J2)

Or, use the DATE function:

=IF(J2<DATE(2010,6,1),"N/A",J2)

--
Biff
Microsoft Excel MVP

"pat67" wrote in message

...



When i write an if statement taht says this =IF(J2<6/1/2010,"N/A",J2),
it always comes up false. How do make it see the date?- Hide quoted
text -

- Show quoted text -

thanks