Hello,

I have a questions why the following formula does not work:

"=IF(AND(Sheet2!A14:A300>AF1;Sheet2!A14:A300<AH1;TEXT(Sheet2!A14:A300;"dddd")=X3);1;0)

Sheet2!A14:A300 are dates values between t.e 1.1.2014-31.12.2014.
AF1 is the start date
AH1 is the end date
X3 is either "Mo,Tu, We.."

The function works if date range is not added, so with only "text()-function."

Any ideas?

Cheers,


T