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

Al’s Produce Stand sells 6 tomatoes for $0.90. Barbara’s Produce stand sells 11 tomatoes for $1.54. Which produce stand has the better buy on tomatoes? Choose

How would the Truman Doctrine assist with the ongoing task of containing communism?

Complete the problem

What are some possible reasons for a labor union? What might a group of people be fighting to change?

Can’t get the answer for this

Manny begins the summer with $200 in his savings account. Each week he adds $85 to his account. Susan begins the summer with $95 in a savings account and adds $

Morgan’s books sold 660 bookmarks last year, in comparison to 528 bookmarks this year. What is the percent of decrease in the number of bookmarks sold annually

What percent of $860 is $731

The two countries remained on _____________ terms despite an incident many feared would hurt diplomatic relations.

Please Help Me!!..........