| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting julian dates
I have a date format that I can not convert to calandar dates;
the dates in column a 1060417 anybody know what I should use to convert to 04/18/06 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting julian dates
=DATE(2000+VALUE(MID(A1,2,2)),VALUE(MID(A1,4,2)),V ALUE(LEFT(A1,1))+VALUE(RIGHT(A1,2)))
-- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "Dvelasq" wrote: I have a date format that I can not convert to calandar dates; the dates in column a 1060417 anybody know what I should use to convert to 04/18/06 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| converting julian day and year to a date? | Excel Worksheet Functions | |||
| Dates from Julian calendar | Excel Discussion (Misc queries) | |||
| Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
| Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
Linear Mode
