I have created formula to determine if a date falls is between two dates.
The formula looks like this (in a Table):
I tested the formula in a dummy workbook and the result was like I expected it to be. 29-02-2016 is FALSE as it is supposed to be.
However, when I copy the formula to another workbook the result is no longer the same. For some reason 29-02-2016 is now TRUE:
It is the exact same formula but with two different results. For some reason the last day of the month is included in the second example and I have no idea why.
Are there any date settings or something else that could be causing this - or am I just missing something obvious?
The formula looks like this (in a Table):
Code:
=AND([@CalcDatesMerged]>EOMONTH(TODAY();-14);[@CalcDatesMerged]<=EOMONTH(TODAY();-1))
I tested the formula in a dummy workbook and the result was like I expected it to be. 29-02-2016 is FALSE as it is supposed to be.

However, when I copy the formula to another workbook the result is no longer the same. For some reason 29-02-2016 is now TRUE:

It is the exact same formula but with two different results. For some reason the last day of the month is included in the second example and I have no idea why.
Are there any date settings or something else that could be causing this - or am I just missing something obvious?