extract date between a given time frame

B

B

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
 
P

Peo Sjoblom

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count non blank cells with a condition? 1
Find then highlight in yellow 6
separating date and time 5
Help to Highlight Excel Row based on Weekly Date Range 2
Reverse Index Match 2
Calculating occupational sick pay entitlement 0
Sum value between two dates and copy to new cell 7
macro help 1

Top