If a value is between two values...

[TripletDad]

This should be simple, but I'm struggling.

If today's date is between two predetermined dates, how can I return a "Yes" answer?

B1: 9/8/2011
B2: 9/14/2011

Then C2 should say "Yes" because today is between B1 & B2...

 

[Steve=True]

=if(and(today()>b1,today()<b2,"Yes","")


Steve=True
www.exceldashboardtemplates.com

 

[pedie]

formula = IF(AND(TODAY()>b1,TODAY()<C1)
,"YES","NO")

 

[TripletDad]

Steve,

I'm sorry - this doesn't seem to work.

... it's missing a parenthasis...
... how does the formula know to stop at B2?

 

[AlphaFrog]

=IF(AND(TODAY() >=B1,TODAY()<=B2), "Yes","")

 

[BrianExcel]

=IF(AND(TODAY()>=B1,TODAY()<=B2),"Yes","No")

 

[pedie]

I just dont know why it does not allow me to paste the formula

formula = IF(AND(TODAY()>b1,TODAY()<b2),"YES","NO")

 

[AlphaFrog]

@Pedie

The forum editor thinks the greater than > and less than < characters are HTML code. If you precede them with a space, it seems to work.

 

[pedie]

@Pedie

The forum editor thinks the greater than > and less than < characters are HTML code. If you precede them with a space, it seems to work.

Alpha, thanks for that... thanks for the trick!

 

[TripletDad]

Thanks guys! It works!!!