Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

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)
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon