Question

Cell B10 contains a date, such as 1/1/2016. Which formula will determine how many days are between that date and the current date, given that the cell containing the formula is formatted with Number Format?

a) =TODAY() - B10
b) =B10 - TODAY()
c) =DAYS(B10, TODAY())
d) =DATEDIF(B10, TODAY(), "d")

Answer 1

The correct formula to calculate the number of days between the date in cell B10 and the current date in Excel is Option A: '=TODAY() - B10'. This assumes the cell is formatted with Number Format to display the result as a number.

Step-by-step explanation:

The question relates to calculating the difference in days between two dates using Excel formulas. Among the options provided:

• Option A (=TODAY() - B10) is correct as it subtracts the earlier date in cell B10 from the current date returned by TODAY() function. The cell must be formatted as a number to display the result correctly.
• Option B (=B10 - TODAY()) would give a negative number if B10 is in the past, which may not be the intended result.
• Option C (=DAYS(B10, TODAY())) is a valid formula but the arguments are in the wrong order for this function. It should be =DAYS(TODAY(), B10).
• Option D (=DATEDIF(B10, TODAY(), "d")) could also be used, but it is more complex and not necessary for this simple calculation.

Therefore, the formula that will correctly determine the number of days between the date in cell B10 and the current date is Option A.