Need to compare dates

[MannyLNJ]

In Cell J2 through J99 I have the date a payment is due. I want it to set Cell M2 through M99 to Yes if the date a payment is due is within 10 days of today's date UNLESS the date in J1 through J99 is after the date in I2 through I99 how can I do this?

[vlady]

..wrong interpret...sorry

should be "or"...
=IF(or(J2<=(TODAY())-10,J2>I2),"yes","no")

[jeffreybrown]

Maybe...

Please Login or Register  to view this content.

[MannyLNJ]

vlady I tried your code by putting it in N2 then copying down and it's not working for me. I think I may not have explained fully my goal

If the Date in Column J is within 10 days of today I want to to show Yes a payment is due in Column N so I have enough time for my payment to arrive unless I already paid it after the statement closed. The statement closing date is in Column I and the last payment date is in column M.

[vlady]

=IF(J2>I2,"No",IF(J2>=(TODAY())-10,"yes","no"))

[MannyLNJ]

=IF(J2>I2,"No",IF(J2>=(TODAY())-10,"yes","no"))

It's still not setting it to yes when I want it. I tried with fake dates before and after the Statement close date. New version attached.

One follow up. How do I not make it show anything if there is no account name in the A column so I don't have a bunch of no's with no corresponding account

[vlady]

=IF(A2="","",IF((J2-TODAY())<=10,"yes","no")) this will give query number 1

just can't get this one...

UNLESS the date in J1 through J99 is after the date in I2 through I99 how can I do this?

all date in J is after I-- so "No"????