How to? Date Function
 

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!

How to? Date Function
 

With your date in cell A1
=DATE(VALUE(LEFT(A1, 4)), VALUE(MID(A1, 5, 2)), VALUE(RIGHT(A1, 2)))
--
HTH...

Jim Thomlinson


"NervousFred" wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!

How to? Date Function
 

On Thu, 17 Jul 2008 13:23:05 -0700, NervousFred
wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!

Data/Text to Columns and select YMD for the format of that column.
--ron

How to? Date Function
 

Ron-

How do I get to the menu to change that specific column's options in 07 excel?




"Ron Rosenfeld" wrote:

On Thu, 17 Jul 2008 13:23:05 -0700, NervousFred
wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!

Data/Text to Columns and select YMD for the format of that column.
--ron

How to? Date Function
 

This won't work becuase the table I am using is imported data.

"Jim Thomlinson" wrote:

With your date in cell A1
=DATE(VALUE(LEFT(A1, 4)), VALUE(MID(A1, 5, 2)), VALUE(RIGHT(A1, 2)))
--
HTH...

Jim Thomlinson


"NervousFred" wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!

How to? Date Function
 

Just relized more of waht you said....diregard my earlier message

"NervousFred" wrote:

This won't work becuase the table I am using is imported data.

"Jim Thomlinson" wrote:

With your date in cell A1
=DATE(VALUE(LEFT(A1, 4)), VALUE(MID(A1, 5, 2)), VALUE(RIGHT(A1, 2)))
--
HTH...

Jim Thomlinson


"NervousFred" wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!

How to? Date Function
 

Worked like a charm thanks!

"Jim Thomlinson" wrote:

With your date in cell A1
=DATE(VALUE(LEFT(A1, 4)), VALUE(MID(A1, 5, 2)), VALUE(RIGHT(A1, 2)))
--
HTH...

Jim Thomlinson


"NervousFred" wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!

How to? Date Function
 

Without formulas...................

DataText to ColumnsNextNextColumn data formatDateYMDFinish


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 08:22:01 -0700, NervousFred
wrote:

Worked like a charm thanks!

"Jim Thomlinson" wrote:

With your date in cell A1
=DATE(VALUE(LEFT(A1, 4)), VALUE(MID(A1, 5, 2)), VALUE(RIGHT(A1, 2)))
--
HTH...

Jim Thomlinson


"NervousFred" wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!

How to? Date Function
 

On Fri, 18 Jul 2008 07:41:01 -0700, NervousFred
wrote:

Ron-

How do I get to the menu to change that specific column's options in 07 excel?




If you have the default ribbon setup:

1. Select Data from the top menu bar.
2. Select "Text to Columns" -- just to the right of center, in the Data Tools
section.

That brings up the Convert Text to Columns wizard; Step 1 of 3
<Next -- Step 2 of 3
be sure it is not splitting the column
<Next -- Step 3 of 3
be sure your column is selected.
Column Data Format
select Date and then, from the drop-down, YMD
<Finish



--ron