Excel formula based on Date input

[crave4excel]

A	B	C	D	E	F	G
From	To	Jan 1	Feb 1	Mar 1	Apr 1	May 1
Feb 1	Mar 15	no	yes	yes	no	no
Feb 15	Apr 30	no	yes	yes	yes	no

<tbody>
</tbody>

Hello
I have a table similar to above. I want to come up with a formula to populate "yes" or "no" from column C3:G4, based on dates entered in column A:B (in red).

Any ideas?

Appreciated.

 

[crave4excel]

If I understand correctly, Now you're comparing the Week?
This will work, I'm using the "Default", where Sunday is the beginning of each week.

Excel 2010

	A	B	C	D	E	F	G
1	from	to	9-Apr	16-Apr	23-Apr	30-Apr	7-May
2	17-Apr	30-Apr	No	Yes	Yes	Yes	No

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet6​

Worksheet Formulas Cell Formula C2 =IF(AND(WEEKNUM(C$1)>=WEEKNUM($A2),WEEKNUM(C$1)<=WEEKNUM($B2)),"Yes","No") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

You are a genius. Thank you!

 

[jtakw]

You're welcome.