Date Transfer

[agoldst4]

I need some help, I am using Excel 2003 and hope someone can help me with this dilemma.

I have an excel sheet with date information on it that is formatted like this:

Sunday, April 27

The year is not imputed into the spread sheet.

Is there a way to have it look like this:

4/27/1997

Thanks

 

[Rick Rothstein]

I need some help, I am using Excel 2003 and hope someone can help me with this dilemma.

I have an excel sheet with date information on it that is formatted like this:

Sunday, April 27

The year is not imputed into the spread sheet.

Is there a way to have it look like this:

4/27/1997

Your question is not entirely clear... for the cells with dates that look like "Sunday, April 27"... are they real dates and, if so, what is the underlying year... 1997 or something else?

 

[agoldst4]

They are in the spreadsheet as text.

IE: Sunday, April 27

There is no year in the spreadsheet.

 

[Rick Rothstein]

They are in the spreadsheet as text.

IE: Sunday, April 27

There is no year in the spreadsheet.

You could use this formula if you want to hard code the year...

=0+(MID(A1,FIND(" ",A1)+1,99)&", 1997")

or this is the year were held in another cell (assumed to be cell B1 for the example formula below)..

=0+(MID(A1,FIND(" ",A1)+1,99)&", "&B1)

Note: These formulas will output a serial date number which you will then need to Cell Format as a Date using the date format of your choice.

 

[agoldst4]

Thanks so much. I used the first formula and it worked!!