CONDITIONAL FORMATTING WITH DATES

[MzTeeRenee]

LEARNING EXCEL FOR WORK AND I AM HAVING TROUBLE TRYNA FORMAT FOR EXPIRED OR SOON TO BE EXPIRED DATES (FROM 30,60,90 DAYS). WHAT RULES CAN I USE?

[#2]

@MzTeeRenee 

Something like this perhaps?

[#3]

yes, jus like that. it's how i start. the i use =TODAY()+30(DAYS) and nothing happens or it formats all dates erroneously

[#4]

I assume you didn't actually write (DAYS)?
Date formatting, along with any date-based calculation goes wrong if the date is a text string rather than a numeric date (a count of days since 'day 0').

[#5]

correct. =TODAY()+30. i had to go back and re-enter all the dates as 05-04-2022 as i initially entered date like this 05.04.22. i then went CELLS; FORMAT; DATE to change the entire column...still not quite right tho...im sure it's something simple. i remember something about a date rule and adding asterick or something before the numbers which may change how the data is read.

[#6]

what is the best way to enter so that the rule calculates correctly