date formula in conditional formatting not behaving as expected

[bh24524]

I have conditional formatting set up to light cells up in column I if the following are true:
Today's Date is less than 6 (so the 1st thru the 5th of any month)
column H has a value in it
column I has a value in it

Based on that, I put in the following formula:

=AND(H2<>"",I2<>"",DAY(TODAY()<6))

The formula doesn't work unless I change it to:

=AND(H2<>"",I2<>"",DAY(TODAY()>6))

But that reads if the day in today's date is greater than 6. Today is August 1 and that is not greater than August 6, so I am just wondering what I am missing here? Was it incorrect to use Day(today()) in the formula?

 

[FormR]

=AND(H2<>"",I2<>"",DAY(TODAY()<6))

Hi, it should be like this:

=AND(H2<>"",I2<>"",DAY(TODAY())<6)

 

[bh24524]

Hi, it should be like this:

=AND(H2<>"",I2<>"",DAY(TODAY())<6)

ahh thank you. I figured it had to be a subtle detail like that.