IF formula for churn

[checkstatap]

Hi All, 

I am trying to write a quick formula for the below. Basically, this should be one answer based on the level of urgency, then if surpassing 9 months, then this customer has Churned. 

3 months

6 Months

9 Months

Churn over 9 months

No Risk - Continued Revenue in all periods

[#2]

Hello @checkstatap

How about if you compare the date to date + 9 months? something like:

=DATE(YEAR(M11),MONTH(M11)+9,1)

This will give you the date in M11 + 9 months so now you can compare the date in M11 to that date and if its larger then churn has happened.

Hope this helops

Georgie