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 Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History