Formula for upcoming expiation Dates

[LindsayBiss]

Hello,

I am looking to see if someone could help me with a formula!

What I am trying to do, is have a cell turn red when an expiration date is within 2 months, and have cell turn green if it is out the of the 4 month period from today's date.

Thank you for your help !!

 

[kevin9999]

This:

have a cell turn red when an expiration date is within 2 months

contradicts what you say within the text box on your image, where you say turn red if within 4 months?!
Based on within 4 months, see if this does what you want:

financials.xlsx
	A	B
1	Expiration
2	2023-12
3	2024-01
4	2024-02
5	2024-02
6	2024-02
7	2024-02
8	2024-03
9	2024-03
10	2024-03
11	2024-03
12	2024-06
13	2024-07
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B13	Expression	=EOMONTH(A2,0)<=EOMONTH(TODAY(),3)	text	YES
B2:B13	Expression	=EOMONTH(A2,0)>EOMONTH(TODAY(),3)	text	YES