Formula to count negative periods and periods in between?

ClaireCat

New Member
Joined
Mar 16, 2011
Messages
6
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?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,108,707
Messages
5,524,424
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top