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

Maxing out means performing the most repetitions possible with a set weight to determine your muscular endurance. TRUE or FALSE I think it is false but I'm n

write this word correctly. panepwesr

1. Why should judiciary be independent?

write a Proposal on Good health

HELP! GIVING BRAINLIEST!! Conjugate the verbs below using the CONDITIONAL tense and reflexive verb format. Example : Yo me ducharia (reflexive conditional) a la

Which statement is true about British relationships after the war?

1289 +(-1236) + (2434) = 0 -1431 O 2345 O 2487 0 -1956

What is the answer with explaining

nursing consideration of nalidixic acid

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