79316320

Date: 2024-12-29 20:53:25
Score: 1
Natty:
Report link

I use this two condition on the date I'm testing against.

=EOMONTH(TODAY(); -1)+1
and
=EOMONTH(TODAY();0)

enter image description here

The other method to test for the date is not taking into account the year and would get you the data from the past years.

You would need to do the following, which is longer.

=AND(YEAR('Date')=YEAR(TODAY());MONTH('Date')=MONTH(TODAY()))
Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Victor Jozwicki