Today() Function

[greend21]

Since today is 2/27 I would expect the below statement to return 1 but it returns 0. Does anyone know why?

=IF(date(TODAY()) = DATE(MONTHEND(TODAY())-1),1,0)

[john_obrien · Accepted solution]

Dan,

It looks like the time of day or fractional part of the date value is making them different.  This should give you the result you want:

=IF(date(TODAY()) = Floor(DATE(MONTHEND(TODAY())-1)),1,0)

The Floor() function returns the integer part of the date value.

Hope that helps.