Excel: counting days

I have a spreadsheet that in column A I input a date when we complete "X" kilometers in column B What I would like to do is count the days and provide an expected number of days to complete when I have a total Km we have days where no work is achieved so I can't deduct first date from last as that would be give a false average

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of February 24, 2014.

For more resources for Microsoft Excel