Match and Index from Date - Oct to Dec Data (Text) is appearing, from Jan to Sep value 0

Dear Excel Community,

I have recently build a Marketing Calendar that takes data from a website (nationalday.com) and updates my excel sheet in a calendar look. the index is the date and day of the week (Sun-Sat). For some reason, the data is appearing when I am selected Oct, Nov, Dec - and from Jan-Aug the data is not appearing - it is giving me zero value.


The formila is as follows;

=INDEX('Marketing Index'!B13:H490,MATCH(C4,'Marketing Index'!A13:A389,0),MATCH(B3,'Marketing Index'!B12:H12,0))

=DATE(D2,MONTH(B2),1)

=TEXT(C4,"DDDD")

The data is being pulled from Appended (Queries Povit Table). I have checked the date format and they are all the same. Note the date (Month) is from a drop-down list of months.

I have created a new measure on the Pivot to give me text value instead of number =CONCATENATEX(Append1,Append1[Holiday],", ")

Can anyone help me, I have searched everywhere and I was unable to resolve it. For some reason the Oct-Dec data is correct, however, from Jan-Sep the value is zero.


Thank you in advance for your genuine support.


Best regards,
Ese