conditional format if date less than current month

[theath]

I am trying to create a conditional formatting formula that will highlight a cell when the month and year for the date listed in is less than or equal to the current month and year.


Cell A2 = Today()

Table column I4 to I16 = any entered date


I want to ignore the days and only focus on the month and year.

 

[Hui]

Theath


Firstly, Welcome to the Chandoo.org Forums


Give this a try:

=AND(MONTH(A2)<=MONTH(TODAY()),YEAR(A2)<=YEAR(TODAY()))

 

[theath]

Great! I see what the issue was now.