How do we convert past date into future date?

Convert text to date.

  • I hope you can assist me with my formula to convert text to date. This is the text: Sunday, February 28, 2010 convert this text to Sun 28-Feb I was hoping with a formula I could change its format to date. I tried using =DATEVALUE(A1) it comes up with an error. I appreciate your assistance.

  • Answer:

    There are so, so many ways to answer this question, and variables depending on how much text you have in what cells, how are they formatted, etc. etc. Can't you just reformat the source cell as Date? Otherwise, I coiuld consider some steps like this: in a new column, format it all as Date, nothing but DDD then formula in that column to get left(cellwithtext,3) this should return SUN and also be formatted as date. use that same type of method for the other parts of it. if you want, email me sheet to [email protected], maybe I can help do a one time clean up.

Miningco.com Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.