How can I target a specific chunk of days, after a specific date, in Google Sheets?-CodePudding

I'm using the below formula to display an expiration warning after 25 days have passed. However, the warning persists after 30 days... I don't want to see the warning text "Expiration Warning" after 30 days. How can I make it so I only see the warning between days 25 and 30, after whatever date is in cell B2?

=IF(AND($B2 <= (TODAY() - 25), ISNUMBER(SEARCH("30 Days", A2))), """Expiration Warning""", "")

CodePudding user response：

something like this?

=IF(ISBETWEEN(TODAY(),B2 25,B2 30),"Expiration Warning",)