Formula not working/updating.

[doumamar]

Hi,

I have built a reminder function which evaluated whether TODAY() is inbetween 2 different dates. Using the below function:

=IF(J6>=H6,IF(J6<=I6,"TRUE","FALSE"),"FALSE")

However the formula comes up as TRUE when:

Today = 29/07/2010
Lower bound = 14/07/2010
Upper bound = 23/07/2010

Any ideas what is going wrong? I even re wrote the formula and it still appeared TRUE. Yet it works for most of the other dates?

Thanks
David

 

[doumamar]

Solved the problem beautifully. Cheers Polsom you're a great help!!!!