Forum Discussion
jamief1503
Mar 23, 2023Copper Contributor
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?
- Mar 23, 2023
Patrick2788 thank you for this, works a treat and I understand the logic 👍
HansVogelaar
Mar 23, 2023MVP
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","")