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

I need to get this done quick and I'm tired so plx help me

Which of the following was banned with the passage of the 1947 Indian Constitution?

Describe in detail the significance of trade routes of oceans

What happened to Robert Kennedy in Los Angeles?

.Morgan has just transferred to a new school. She has made some friends, but they are into activities that she generally is not into, like vaping and drinking a

Unusual names can be a symbol of solidarity with the african american community, whereas less distinctive names can be a form of __________ with the majority cu

Helpppppp asap with this

Please help me?? Define harassment, and list three ways a police officer could safely respond to such threats in the workplace.

What will be the result from running the following program? print("Grades") print(100) print(93) print(82) print("Total") print(100+93+82)

Which factor best accounts for the affordability for ford model t automobiles in the 1920s