Conditional Formatting in Months, 6 months from expiry date

[sher13CA]

I have a list of expiry dates (Y M D) and would like to highlight the date if it is within 6 months of expiring. I have some dates in 2022, and some in 2023 and 2024, but I only want to highlight by Month not by the exact Day.
I have searched high a low for something like this. Any help you can provide would be greatly appreciated.

 

[dave3009]

You can try using formula is

=DATEDIF(TODAY(),A2,"m")<=6

If you need to perform a separate check for expired products (which would result in #NUM error) then you can wrap the formula in ISERROR

 

[sher13CA]

You can try using formula is

=DATEDIF(TODAY(),A2,"m")<=6

If you need to perform a separate check for expired products (which would result in #NUM error) then you can wrap the formula in ISERROR

Thank you, I can work with this, greatly appreciated

 

[dave3009]

Glad we could help and thanks for the feedback.
Remember to mark the solution when you're ready. Cheers, Dave