Hello,

I cant get the following to work.

=IF(P2>HLOOKUP(O1,$E$14:$P$16,3,0),1,0)
But range "O1" is =TODAY()

When I remove the formula in "O1" it works. I guess it can't reference a cell with a formula?

How can I get this to work?

Thank you,