Date formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date that is imported in to Excel at text and will not allow me to
reformat the date by using format cell.

It is shown as 2005/06/01 for May 6, 2004. I need a formula that will take
show the same date as mm/dd/yy.

Any help will be appreciated.

Thanks.
 
=DATEVALUE(A1), where cell A1 contains the text in question. format the
result in any date format you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference between two date/time values 5
Date Format 2
Pasting Dates in Excel 1
Compare dates (re-stated) 1
Change date format in Excel footer 2
date and time difference 19
Criteria For SU<IF 5
separating date and time 5

Back
Top