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?

Question

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 :

Otras preguntas

a bicameral, or to two-house, congress was a feature of which plan for the federal government presented at the Constitutional Convention?

What happens to the number of coffee shops if the wage increases?

Rio is going to the hospital for an operation. He is sent the following text from the hospital. Name one thing that rio may need to take to the hospital?

How to solve a quadratic equation by taking square roots?

Richard grassgreen was executive vice president and then president and chief operating officer of kinder-care, inc., the largest proprietary provider of child c

find the 8th term in the geometric sequence which has a first term of 10 and a common ratio of 1.75.

How often can you be called for jury duty in texas?

Yellowstone possesses nearly 60 percent of the world's geysers. The Upper Geyser Basin is home to more geysers than any other part of the park. Within one squar

Why might you use groups on a linux system?

meerkat18 meerkat18 · Answer 1 · 2018-01-16T08:55:34+01:00

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