If date is between then add 1

Originally Posted by FDibbins

Couple of shots in the dark - hard to say without seeing this with some data....

1. that looks like an ARRAY formula, did you enter it using CTRL SHFT ENTER?
2. You said X3 is either "Mo,Tu, We.., but your TEXT() is DDDD?
3. Are your dates actual dates, and not text that looks like a date? Test with =ISNUMBER(cell-ref)...FALSE indicates text

Hi!

Thanks for the reply. Heres my answers:

1. I used array, so it put up with ctrl shift enter.
2. It was mistake X3 is monday, tuesday, etc. Not mo, tu, we etc., sorry
3. Dates are actual, so the mentioned test gives true.

I just don't get it :/

Banaticus t.e is e.g, in swedish though.

Regards,

T