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