Excel Date Mapping

Copper Contributor

Screenshot 2023-03-23 192918.png

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



4 Replies


Assuming that your screenshot has A1 as upper left cell, enter the following formula in B9, then fill down and to the right:




Perhaps with COUNTIFS:

best response confirmed by jamief1503 (Copper Contributor)

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

You're welcome! Glad I could help.