O

#### Obonden

dd.mm.yyyy in both columns. In a third column (cell format text) I have this

formula

=IF(O2>TODAY();IF(P2<TODAY();"JA";"");"")

which I expected to return the text JA if todays date is between the date in

column O and P, and blank if it is not. But the formula returns no value at

all, only the formula-text.

What is wrong?

2) When I try to copy the formula down, O2 and P2 don't change to O3 and P3.

The reason is that Excel don't consider the text as a formula, I guess...