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

Question

morpeh [17]

3 years ago

5

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?

Computers and Technology

2 answers:

Inga [223] · Answer 1 · 2022-04-27T09:29:25+03:00

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,"")

Jet001 [13] · Answer 2 · 2022-04-27T07:17:26+03:00

Jet001 [13]3 years ago

3 0

<span>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")</span>