I currently have a spreadsheet which tells me how many months build period we have, buy calculating how much capex we have, and over what time.
Issue I have is, if people spend X amount one month, and then X amount in 4 months time, my report will pull me off 2 months, whereas it should be 5 (1st spend to last spend) as it took 5 months to build it.
**no idea how to add an image of this, sorry - but here's a link to it! https://drive.google.com/file/d/1rQVKfJbEiQMFMcyGgpQLvUW2vuYqOr2H/view?usp=sharing
You'll see my formula brings back 4, as this is the number of capex items - but I really need it to bring me back 15.
Is there anyway to do this?
Issue I have is, if people spend X amount one month, and then X amount in 4 months time, my report will pull me off 2 months, whereas it should be 5 (1st spend to last spend) as it took 5 months to build it.
**no idea how to add an image of this, sorry - but here's a link to it! https://drive.google.com/file/d/1rQVKfJbEiQMFMcyGgpQLvUW2vuYqOr2H/view?usp=sharing
You'll see my formula brings back 4, as this is the number of capex items - but I really need it to bring me back 15.
Is there anyway to do this?
