Insert a column for the Start Date (column D for this example) then in the Days Unfilled column F for this example, enter in F7.

Formula: copy to clipboard
=today()-d7