Real estate calculation

[excelzrf]

Hello,

I am looking for a formula that will allow us to automatically fill in the sales of units for a given assumption.

The assumption is that we will sell 2 houses every other month. I have these as drivers of:
2 sales
Every 2 months

I need it to populate the cells automatically. I need it to be:
1/1/23 - 0 sales
2/1/23 - 2 sales
3/1/23 - 0 sales
4/1/23 - 2 sales

and so on. How can I accomplish this?

 

[Peter_SSs]

What else can I provide to help out?

Copy my sample data from post #18 (if such data is possible), manually fill in the expected results assuming E6 & E7 on 'Assumptions' are both 3 and post that with XL2BB