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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History