Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to lookup date on tab in excel and populate date on calen | Excel Worksheet Functions | |||
Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
Function Excel:If a Dateactual date create a RED alert in a cel? | Excel Programming | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |