Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date(Year,Month,Day) not returnign correct date
In the AS400 it stores date as monthdayyear and does not seperate
them. So when it spits it out into excel this is what you get. 10012000. So the date shoudl be October first 2000. When I use this formula if 1001200 was in cell A1 it woudl be =Date(Right(Year(A1), 4),Month(Left(A1,2)),Day(Right(Left(A1,4),2))) It returns the date 10-1-1905. Is this a bug or did I do something wrong? I have tried using value and Int to straighten it out with no luck. Thanks, Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Sorting a date by month, date and then year. | Excel Discussion (Misc queries) | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
pick up date, month and year from a date | Excel Discussion (Misc queries) | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) |