Add the current date in cell C10. Then, you can use any of
these formulas to determine the number of days between cell B10 (9/1/2014) and
the current date:
=IF(OR(C10="",B10=""),"",INT(C10-B10+1))
=IF(NOT(OR(ISBLANK(C10),ISBLANK(B10))),C10-B10+1,"")
You just have to enter the formulas in an empty cell.
