Ian needs to extract the day of the month from the date entered as a serial number 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) )
Correct Answer:
Verified
Q11: What is the correct formula to insert
Q21: Stuart inserts the formula '=YEAR ('23-Aug-2012)' into
Q30: A student types the formula '= YEAR(
Q34: Sheila wants to extract the hour from
Q438: Which of the following keys should you
Q439: Megan wants to refine the appearance of
Q440: To insert only the current date in
Q441: Cell A5 contains the number 24.7835.In another
Q446: Which of the following formulas can you
Q448: Laura is changing data in a worksheet,
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents