Conditional Formatting for Past Due Date

[gymwrecker]

Need help with a conditional formatting formula that will change the text in B2 to "red" when the date is past the six-month mark.

For example, 15 Mar 23 returns 0 years, 8 Months and 16 days from today (based on the formula in B2.

A2=15-Mar-23
B2 = =IF(G5,DATEDIF(G5,TODAY(),"y")&" Years, "&DATEDIF(G5,TODAY(),"ym")&" Months and "&DATEDIF(G5,TODAY(),"md")&" Days","")

 

[Joe4]

You can simply use the EDATE function to add/subtract 6 months from a date, and then you can compare that date to another date, i.e.
to find if a date is more than six months in the past, if the date being checked is in cell A2, the formula would look like:

=A2<EDATE(TODAY(),-6)