Calculating Lag Period of 2 Months

Essentially Row 11 comes from a Rental calculation sheet and it shows the accummulated no. of rooms we are renting in a particular month
In Month 0 the 3 is rooms is owned by us to its always there and can be rented out immediately
But for the rooms we are renting if we want to sub lease these rooms, we think it will take at least 2 months to sublease so a lag period of 2 month
So Row 13 is the Row I want to see the number as in the example (sheet)--- hardcoded
For examples,

Month 0 - 3 rooms
Month 1- 3 rooms
Month 2- 3 rooms
Month 3- 5 rooms (2 rooms added from the rooms which were rented in Month 1)


With Row 13 I can calculate my revenue and expenses so its more important to me.

I tried various ways but could not come up with a formula to do so. I would really appreciate if any help on this.

Try, G13=IF(MOD(G8+1,2)=0,MAX($F11,F13)+OFFSET(G12,,-2),MAX($F11,F13)), copy across.

Originally Posted by josephteh

Try, G13=IF(MOD(G8+1,2)=0,MAX($F11,F13)+OFFSET(G12,,-2),MAX($F11,F13)), copy across.

Thank you so much Josephteh, works perfectly. Appreciate you help

How about this?

Please Login or Register  to view this content.

Try in G13: =MAX(D11,$F$11)+E12 or =MAX(OFFSET(F11,,-2),$F$11)+OFFSET(G12,,-2), copy across.

Originally Posted by josephteh

Try in G13: =MAX(D11,$F$11)+E12 or =MAX(OFFSET(F11,,-2),$F$11)+OFFSET(G12,,-2), copy across.

Worked perfectly, thank you again Josephteh

You are welcome and thanks for the Rep!

If lag period is n months, change -2 to -n: =MAX(OFFSET(F11,,-n),$F$11)+OFFSET(G12,,-n)