Wildcard in a if statement

[#1]

Hi Qlik,

A table showing which days a site has deliveries of which looks at little like this:

Site	Delivery days
A	1,2
B	2,3
C	4
D	1,3,5

I want to build a table that says whether or not a site has deliveries on a day. I want the table to look like the below (with a filter on for Site A).

I am using the equation:

if(weekday(BlankDate)=

(if(wildmatch([Preferred Scheduled day],'*1*'),'Mon',

if(wildmatch([Preferred Scheduled day],'*2*'),'Tue',

if(wildmatch([Preferred Scheduled day],'*3*'),'Wed',

if(wildmatch([Preferred Scheduled day],'*4*'),'Thu',

if(wildmatch([Preferred Scheduled day],'*5*'),'Fri')))))),'y','n')

However this only returns the 01/01/1991 as 'y' the next day is a no.

Can anyone please help or come up with a better solution?

Date	Day	Delivery
01/01/1991	mon	Y
02/01/1991	tue	Y
03/01/1991	wed	n
04/01/1991	thu	n
05/01/1991	fri	n
06/01/1991	sat	n
07/01/1991	sun	n