Does anyone know how to INCLUDE the month of May or June data when the current month is May and if the current month is June but all other months exclude the "current" month?
I'm working with
to exclude current month, however I need ALL months when the current month is May or current month is June. Meaning only in the month of May or month of June I need the <>Month(Date()) to NOT take affect.
does not work, it results in Null
does not work, it also results in Null
There has to be a way to do this, anyone know the correct formula?
I'm working with
Code:
<>Month(Date())
Code:
<>Month(Date()) and (Month(Date()) Not In (5,6))
Code:
<>Month(Date()) and (Month(Date()) In (5,6))
There has to be a way to do this, anyone know the correct formula?