Excel Date Mapping

[jamief1503]

I am trying to write some logic to populate the yellow above. Have tried various options but keep hitting blocks. Anyone able to help?

[#2]

@jamief1503 

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","")

[#3]

@jamief1503 

Perhaps with COUNTIFS:

=IF(COUNTIFS(employee,$A9,Start,"<="&B$8,End,">="&B$8)>0,"H","")

[#4 · Accepted solution]

@Patrick2788 thank you for this, works a treat and I understand the logic 👍

[#5]

You're welcome! Glad I could help.