Today() Function

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Today() Function

john_obrien — Tue, 27 Feb 2018 18:54:18 GMT

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.