Question

Cell B10 contains a date, such as 9/1/2014. Which formula determines how many days have passed between that date and the current date?

Answer 1

You can use the two formulas below that should be entered into a blank cell where you can get the result. In this case, to be able to determine the number of days between cell B10 (9/1/2014) and the current date, then;

=IF(OR(C10="",B10=""),"",INT(C10-B10+1))=IF(NOT(OR(ISBLANK(C10),ISBLANK(B10))),C10-B10+1,"")

Answer 2

If using excel, you can use this formula: DATEDIF(start_date, end_date, unit) For instance, DATEDIF(9/1/2014, today, "d") or DATEDIF(B10, today, "d")