How do I...find if e2>=4/1/10 and if f2<=4/31/10

If the values you are checking for are dates, then you can't do it. There is no such date as 4/31/2010.

My mistake, If the dates were 4/1/2010 - 4/15/2010 would there be a way?

Try this: =IF(AND(E2>=DATEVALUE("4/1/10"), F2<=DATEVALUE("4/15/10")),TRUE,FALSE)

The reason I used DATEVALUE("4/1/10") is so that Excel doesn't think you mean 4 divided by 1 divided by 10.

DATEVALUE will force Excel to compare dates.

Thank you. II appreciate your help.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History