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

Find an equation of the tangent line to the curve at the given point. y = 7x + 9 cos(x), p = (0, 9)

in the play endgame, why does hamm fear the child

I need the answers to these.

What is a serenade?

A parabola has a vertex at (2,5) and opens down, is reflected in the y-axis. What is the image of the vertex after the reflection? A. (-2,-5) B. (2,5)

Your parents are looking at buying a new car for you. the dealership informs you of all your choices. there are 5 colors and 8 different options. because of you

If increasing 50 by x% is equal to the result of decreasing 70 by x%. what is the value of x?

Which of the following is an accurate statement? The Aztec government was made up of city-states that were loyal to their kings. The Maya Empire was ruled by on

Smoking can put smokers at risk for health problems but smokers are also subject to social consequences write a short letter to a friend or family member urging

QUESTION 6 What is the mean of the following set of data? Round your answer to two decimal places. 78, 82, 91, 100, 78, 92, 82, 77, 80 a. 91.21 b.