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