Hi Cathcam ,
You can either change the formula you have
into an array formula by hitting Ctrl+Shift+Enter instead of just enter. Doing this will enclose your formula in curly brackets.
Or you can use the COUNTIF function:
Best of luck with the wedding :-)
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.