> > >

Excel MCQs

Cell A1 has text in the format YYYYMMDD. How do you convert this to a valid Excel date?

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

=CONVERT(A1,"YYYYMMDD",Date)

=DateText(A1)

=DATEVALUE(A1)

=MID(A1,5,2) & "/" & RIGHT(A1,2) & "/" & LEFT(A1,4)

Answer

Correct Answer: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More Excel MCQ Questions

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

Join our newsletter for the latest updates.

Coming Soon

Our Products