extract date between a given time frame
 

I have the following problem:

If a certain date falls within a certain time frame (e.g. 03/04/07 falls
within 01/01/07 till 31/12/07), than cell should display "Yes"; If it
doesn't, exel cell should display "No".

How to do this (I'm new on the block)?
Thanks

extract date between a given time frame
 

=IF(A2="","",IF(AND(A2=B2,A2<=C2),"Yes","No"))

where A2 holds the date you want to test for and B2 hold the lower date
limit and C2 the upper

--
Regards,

Peo Sjoblom


"B" wrote in message
...
I have the following problem:

If a certain date falls within a certain time frame (e.g. 03/04/07 falls
within 01/01/07 till 31/12/07), than cell should display "Yes"; If it
doesn't, exel cell should display "No".

How to do this (I'm new on the block)?
Thanks