Forum Discussion
Excel Date Mapping
I am trying to write some logic to populate the yellow above. Have tried various options but keep hitting blocks. Anyone able to help?
Patrick2788 thank you for this, works a treat and I understand the logic 👍
Assuming that your screenshot has A1 as upper left cell, enter the following formula in B9, then fill down and to the right:
=IF(SUMPRODUCT(($A$2:$A$6=$A9)*($B$2:$B$6<=B$8)*($C$2:$C$6>=B$8)),"H","")
Patrick2788 thank you for this, works a treat and I understand the logic 👍
- You're welcome! Glad I could help.
