Ian needs to extract the day from the date 5/31/2017 entered in cell A1.Which formula can he use to do this?
A) =DAY(A1)
B) =DAY("A1'')
C) =DATE(DAY(A1))
D) =DATE("DAY"(A1))

Question

Quizplus · Accepted Answer

The formula =DAY(A1) will extract the day from the date in cell A1. Option B is incorrect because it contains an extra set of quotation marks. Option C is incorrect because it tries to use the DAY function inside the DATE function, which is not necessary since the date is already in cell A1. Option D is incorrect because it uses quotation marks around "DAY", which is not a valid function.

Ian Needs to Extract the Day from the Date 5/31/2017