I am trying to find a nested if and statement

November 2, 2010 at 05:19:16
Specs: Windows Vista
How do I...find if e2>=4/1/10 and if f2<=4/31/10

See More: I am trying to find a nested if and statement

Report •


#1
November 2, 2010 at 05:59:45
If the values you are checking for are dates, then you can't do it.

There is no such date as 4/31/2010.


Report •

#2
November 2, 2010 at 06:30:59
My mistake, If the dates were 4/1/2010 - 4/15/2010 would there be a way?

Report •

#3
November 2, 2010 at 06:38:29
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.


Report •

Related Solutions

#4
November 2, 2010 at 07:01:47
Thank you. II appreciate your help.

Report •


Ask Question