There may be a more elegant way to do this but:
Create an extra column D and enter the formula
and copy down as far as needed.
The days actually taken, not including today, is then given by
you need to substite 4 by the row that your data ends in.