officialtyree7669 officialtyree7669
  • 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 :

meerkat18
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

Otras preguntas

what is 1,400 time 6
Solve 4(x-5) = 2 Can you show your working please?
Which of the following was named after an island in the English Channel?
How to get the equivalent fraction of 11/16
0.0136 g + 2.70 × 10-4 g - 4.21 × 10-3 g = ? How many digits to the right of the decimal point should be used to report the result?
what value of n will make the rational number -17\n an integer
If a material contains 3 elements joined in a fixed proportion it is an
american colonists organized the first continental congress to?
.84 is 10 times as much as
what is the prime factorization for 34