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

You hit and damaged a parked car while riding your bike. What kind of policy would u need for coverage? Auto Dental Dissabilty Fidelity Bond Heath Homeowners Li

Select the correct answer. On what does the media’s influence on society depend? A. directors and writers B. reporters and producers C. availability and popu

There are 15 boys and 13 girls in Mr. Garcia's class. What is the ratio of girls to boys?

NEED HELP WITH TRIG MUST SHOW FULL WORK PLS

If you multiply x to the second power by x to the seventh power, what is the product?

Is 4:3 equivalent to 16 : 12? How do you know?

REDUCE EACH FRACTION TO ITS LOWEST TERM 1) 56/72 2) 20/90 3) 8/64 4) 10/50 5) 48/54 6) 5/10 7) 15/20 8) 30/110 9) 7/49 10) 10/35 11) 16/20 12) 9/30 13) 12/40 14

Which force does the shuttle overcome to create an unbalanced net force as it initially lifts from the ground? Air resistance Friction Gravity Thrust of roc

How did Mau Mau try to gain independence for Kenya? A) He started a campaign of peace modeled after Ghandi in India. B) He used the tactics of murder and intimi

sharonda is plotting quardrilateral pqrs on the graph below. she will plot the fourth and final vertex, s, at (9,5). what will be the length of the side ps?