In E4 I put the formula = IF (AND (MONTH ($ A4) = MONTH (S $ 3), YEAR ($ A4) = YEAR (S $ 3)), $ B4, "") then "dragged" to the right and down and in D4 I put the formula = IF (AND (MONTH ($ A4) <= MONTH (S $ 3), YEAR ($ A4) <= YEAR (S $ 3)), $ B4, "") then "dragged" down.
I change the name of month with real date.
See the attachment.
Bookmarks