Conditional formatting - month

[ashani]

Hi gurus,

I wonder if anyone please guide me - i have set the conditional formatting using below formula to turn red after 179 days - however I would like to have a 6 calendar months instead of days :

=A8+179<=A9

Please can someone help me how to have conditional formatting to turn red after 6 months instead of 179 days.

thank you

 

[Fluff]

How about
=edate(A8,6)<=A9

 

[ashani]

Thank you Fluff - extremely helpful.

 

[Fluff]

You're welcome & thanks for the feedback.