Cohort for app downloads, calculate use of app 3 months per year (every year).

Hi there, I am trying to figure out a way to make a 60 month (5 year) cohort work.
I'm just not smart enough to figure this out, I hope someone in this forum can help me with this.

I need to calculate the app users for any given month
1. Every month people download the app.
2. But the app only gets used for the first 3 months every single year.

How do I make it so that the number only appears 3 months in every 12 months ....
Untill now I have made a work around by just multiplying the app downloads by 25% (12months *25% = 3 months) to get to the 3 months usage on average.
But I would like to have a more sophisticated solution.

Untill now I have this formula in the cells: =IF($A8=B$7,B$6,IF($A8>B$7,0,(A8*(100%))))
Starting cell is B8
$A8=D#B$7 are the month
B$6 is the number of app downloads

I just don't know where to begin.

Thank you for your help.

SORRY I HAVE NOW ADDED THE ATTACHEMENT EXCEL 2013
See also explanation in the file.

This is an example with CHURN. However what I need is that the first download in jun 22, is only active for 3 months per year.
In the rows jun 22 and jul 22 I have marked the 9 month which should disapear. And reapear in the following year. To show you what I mean.

Please attach example workbook to ease people to understand the case, see yellow banner on the top of the page

Try this in D8, then copied down and right:

=IF(MONTH($A8)=MONTH(D$7),D$6,IF(MONTH($A8)=MONTH(C$7),C$6,IF(MONTH($A8)=MONTH(B$7),B$6,0)))

(it will throw errors in the first two columns as it tries to reference a column to the left of A, but these are all 0 anyway so shouldn't need a formula)

Edit: This doesn't work. It repeats every year so e.g. Jun22 is counted in Jun23.

Greg's solution is good, but XLOOKUP won't work if the OP is still using Excel 2013. I'll think of another solution.

@Nick

Just add an error trap:

=IFERROR(your_formula,"")

Thank you all for helping out.

Thank you Gregb11 for your time trying to help. Unfortunatly it did not work in excel 2013.
But nick.williams solution did do the trick.

So Nick kudos to you. And thank you for putting in the Churn. It works just like I wanted.

Have a great weekend all.