CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaconditional-formatting
Beth
Beth

Reputation: 37

Google Sheets - Conditioning Formatting for Date Expiry

I have a spreadsheet with different dates for different clients where the contract expiry date turns red when it's due to expire in 60 days or overdue. The formula I am using is:

=AND((X:X>0), (X:X<60))

But it seems it's not looking at the year, so for example I have a date of 01/09/2021 which is red as the date has already passed (01/09), but it's showing red when it shouldn't because its 2021.

Any ideas? :) Thanks!!

Upvotes: 0

Views: 1035

Answers (1)

player0
player0

Reputation: 1

try:

=(X:X>=1)*(X:X<=TODAY()+60)

enter image description here

Upvotes: 1

Related Questions