Format control data - values to be input differently on different tabs

Originally Posted by JeteMc

Try the following modifications
For April: =SUMPRODUCT(('Holiday Sheet'!$A$3:$A$100=A2)*(MONTH('Holiday Sheet'!$B$3:$B$100)=4)*'Holiday Sheet'!$D$3:$D$100)
For May: =SUMPRODUCT(('Holiday Sheet'!$A$3:$A$100=B2)*(MONTH('Holiday Sheet'!$B$3:$B$100)=5)*'Holiday Sheet'!$D$3:$D$100)
Let us know if you have any questions.

Hi Jetemc

Thank you for your reply. The dates don't change on the holiday sheet tab therefore the number of days remain the same and subsequently this is still showing for april and for may. Can you please advise? thank you