crave4excel
New Member
- Joined
- Feb 2, 2012
- Messages
- 45
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.
Last edited: