+ Start a Discussion
KIBLKIBL 

Current Month + 3 Months

I have the following formula to return True if the Close date is in the current month or the next 3 month but it doesn't take into account the Year.   What do I add to make sure the Close date is in the same year as Today?

 

IF ( OR
(MONTH( CloseDate ) = MONTH(TODAY()),
(Month(CloseDate) = Month(Today()) + 1),
(Month(CloseDate) = Month(Today()) + 2),
(Month(CloseDate) = Month(Today()) + 3)),
"True", "False")

Steve :-/Steve :-/

Does it have to be the literal "Month" or would TODAY () + 90 work?

KIBLKIBL

It has to be the literal month. 

Steve :-/Steve :-/

Okay that's gonna be tricky for November and December, lemme give it a shot...