Like to get this fixed.
Cell a3 shows the date, like 19-jun. In cell a2 I test if it is a monday to a sunday. The result will be showed like "Mo", "Tu" etc.
In another cell I like to create a test something like this; If a2 is equal to "Fr." "Sa" or "Su" and another cell E41<=$K$74 then te result must be " " (empty cell) otherwise show the word "closed.
Can't get the combination of all this in one formula, anyone an idea ?