Excel formula based on Date input

[crave4excel]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]From[/TD]
[TD]To[/TD]
[TD]Jan 1[/TD]
[TD]Feb 1[/TD]
[TD]Mar 1[/TD]
[TD]Apr 1[/TD]
[TD]May 1[/TD]
[/TR]
[TR]
[TD]Feb 1[/TD]
[TD]Mar 15[/TD]
[TD]no[/TD]
[TD]yes[/TD]
[TD]yes[/TD]
[TD]no[/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD]Feb 15[/TD]
[TD]Apr 30[/TD]
[TD]no[/TD]
[TD]yes[/TD]
[TD]yes[/TD]
[TD]yes[/TD]
[TD]no[/TD]
[/TR]
</tbody>[/TABLE]

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
from	to
No	Yes	Yes	Yes	No

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]9-Apr[/TD]
[TD="align: right"]16-Apr[/TD]
[TD="align: right"]23-Apr[/TD]
[TD="align: right"]30-Apr[/TD]
[TD="align: right"]7-May[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]17-Apr[/TD]
[TD="align: right"]30-Apr[/TD]

</tbody>

Sheet6​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=IF(AND(WEEKNUM(C$1)>=WEEKNUM($A2),WEEKNUM(C$1)<=WEEKNUM($B2)),"Yes","No")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

You are a genius. Thank you!

 

[jtakw]

You're welcome.