35.6k views
1 vote
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?

User Lekens
by
8.4k points

1 Answer

2 votes

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.