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

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

Which is a major function of diffusion in cells? A. to produce proteins B. to carry out mitosis C. to convert food into energy D. to get rid of waste material

In the Meselson-Stahl experiment, bacteria were grown in medium containing 15N and were then transferred to medium containing 14N. After three rounds of DNA rep

Which term describes the example below?A child with no freckles has a mother who has freckles and is heterozygous and a father who has no freckles and is homozy

In which quadrant does the point (–10, 9) lie? A. Quadrant I B. Quadrant II C. Quadrant III D. Quadrant IV Need an actual answer...

First president of brazil

Is this Linear y=4000-70x if it is how do you know

Round 8.61 to the nearest tenth.

what does y =mx +b mean and how do you use it to solve problems? whats the different between y=mx+b and y=mx + c

Which one of the following phrases describes many countries within Asia and Africa? A. LDCs experiencing slow population growth B. MDCs experiencing slow popula

is the sun considered a star?