counting days

[rantnrave]

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

 

[BrianMH]

Yeah they had 3 solutions and that was the one listed for numbers only excluding blanks. Oh well learn new ways every day.