Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days until the end of the semester. Which function should you use?

Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days until the end of the semester. Which function should you use?


a. =YEARFRAC(B1, B2)
b. =DAY(B1)
c. =DAYS(B2, B1)
d. =DAYS(B1, B2)


Answer: c. =DAYS(B2, B1)


Learn More :