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?

Question

02-01-2018
Business

contestada

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?

Respuesta :

Otras preguntas

The textbook uses climographs. Climographs are useful in ________. predicting weather classifying climate recording relative humidity judging the strength of st

bill is purchasing Hammers and wrenches for his workshop and he would like to spend under $110 each Hammer cost $9 and each wrench cost for

Which calculation IS equivalent to 12 x (24 + 17)?A. 24 X (12 + 17)B. 17 + (12×24)C. 12 X 24 + 17D. 41 X 12

The weight of meteorite A is 6 times the weight of meteorite B. If the sum of their weights is 140 tons, find the weight of each Meteorite A weighs tons, and me

Geometry B: Fill In the Blank

how did the American men feel about the bombing of Hiroshima and Nagasaki?

in initially dismissing lamarr’s idea of spread spectrum technology, the u.s. navy made the error of

Which equation is equivalent to log5x3 - logx2 = 2?.

Geometry B: Fill In the Blank

meerkat18 meerkat18 · Answer 1 · 2018-01-16T08:55:34+01:00

meerkat18 meerkat18

16-01-2018

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.

Answer Link