Hello,

I need a formula to be a follow up field to calculate 30 days(from previous cell); identify by color when date is within 2-3 days of 30 day follow-up

So in J2, I have a date. I need K2 to follow up that date by 30 days. I know the formula is =J2+30. That is the locked formula. Then I go to Conditional Formatting - Highlight Cell Rules - More Rules and then I have a place to put the formula in. I made it Cell Value is less than or equal to:

So far I have =K2-TODAY()-3
I formatted the font to be red when it alerts.
But the formula is incorrect. I have no idea how to make it work.

Any help would be appreciated.

Thank you