Hi all
Firstly apologies if this has been dealt with before!
I have a sheet that contains quarterly rental data for an office building in a single row. Each cell along the row is the next quarter in the sequence. The start date for the rent is the first quarter after construction finishes but this might change if I build in a void period or if we assume construction takes longer..
In another page I would like to express the rent annually y1 y2 y3 etc.. With y1 starting on the first quarter that rent is paid. Y1 would be the first 4 quarters (1-4). Y2 would be quarters 5-8 and so on
Can anyone help with this? It's been driving me nuts!
Bookmarks