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
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