Running total of days

Hi there,

Basically I'm trying to keep track of days from a certain date. This should be easy but my brain refuses to play along tonight

So in column E I have a start date, e.g , 28/12/2014

In column F I want it to count every day, 1 , 2 , 3 , 4 , 5 etc up until;

In column G, I input my finish date. e,g 12/01/2015

At that point I want Column F to stop counting and be left with '15' (the days between 28/12/2014 and 12/01/2015)

I have a formula to count the number of days between those two dates; [=IF(G3<>"",G3-E3,"") once I insert the finish date, but now want to count the days daily as well

any suggestions? should be simple

Hmm, doesn't quite seem to work. My other formula is in H3. I've attached a screen shot of what it looks like. Quite simple really.

excelshite.PNG

E3 = my Start date
F3 is where I want the running counter
G3 is my Sign Off Date (this is where I want the counter to stop running)
H3 is count the days between start and finish date. (this is where my formula is)

All uploaded.

Hehe, I know it's hard to explain these things.

That formula works perfectly. Thanks for the help man, appreciate it!

Ah, the only thing that seems to be sticking is that when I drag the formula down, the empty cells show '42001' if there's no 'Start Date' entered on the adjacent column. It's no biggie. I'll just keep dragging it down every time I enter a start date

Beautiful. Dragged that sucker all the way down.

thanks you very much and a good day to you sir.

Not there at the moment. In NZ for the next 12 months on a contract. But I hear from family it's a bit cold. Lovely and warm here though