Formula for conditional formatting of expiration date in 2 months

[Penny151718]

Hi,
I am trying to create a formula to conditionally format expiration dates that occur in 2 months. In Column A, I have =Today(). In Column B, I have various expiration dates in format MM/YY. I've tried =AND(DATEDIF($B2,$A$2,"m")>2,$B2<1). Any help is greatly appreciated!

[BanginMyHeadOnMyDesk]

If I've understood correctly, maybe this will help

Please Login or Register  to view this content.

B.

[maras_mak]

Maybe it will be okay.
A1 =Today()
Expiration dates in kol. B from B1.
Select all dates in col. B.
Formula for conditional formatting

Please Login or Register  to view this content.

[Penny151718]

Unfortunately this did not work. I am able to use the built in conditional formatting to highlight the dates that occur in “next month”. I want it to also highlight the dates that expire in 2 months. So in July, the worksheet highlights expiration dates in Aug 2019. I want it to highlight expiration dates in Sep 2019 too.

If I've understood correctly, maybe this will help

Please Login or Register  to view this content.

B.

[Penny151718]

Unfortunately this did not work. I am able to use the built in conditional formatting to highlight the dates that occur in “next month”. I want it to also highlight the dates that expire in 2 months. So in July, the worksheet highlights expiration dates in Aug 2019. I want it to highlight expiration dates in Sep 2019 too.

Maybe it will be okay.
A1 =Today()
Expiration dates in kol. B from B1.
Select all dates in col. B.
Formula for conditional formatting

Please Login or Register  to view this content.

[Aardigspook]

Welcome to the forum.
If I understand your later posts correctly, you don't want to highlight dates 'within the next 61 days' but dates in the next two calendar months, regardless of how many days in the future they are. If that's correct, read on. If I'm wrong, please let us know.

To highlight all expiry dates in next month, use this as your CF formula:

Please Login or Register  to view this content.

To highlight those in the following month, change the 1 to 2:

Please Login or Register  to view this content.

To highlight both, combine them with OR:

Please Login or Register  to view this content.

Alternatively, you can use AND:

Please Login or Register  to view this content.

The advantage of this second formula is that you can easily expand it to highlight the next 3 months, 4 months, etc, just by changing the last number. The 'Or' formula would quickly become unwieldy for those cases. I know that's not what you're asking for right now, but maybe it's of use for the future.

Hope that helps.