| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to convert julian date to regular calendar date
I need help converting Julian Date to regular calendar date.
I have from 5000 €“ 10000 Julian Dates in one column. Ex. Col A need converted to 4001 = 1 Jan 04 5001 = 1 Jan 05 5030 = 30 Jan 05 Any help would be much appreciated. Thanks Ron -- Ron |
|
#2
|
|||
|
|||
|
Use the formula =Date(int(a1/1000),1,mod(a1,1000))
-- Regards, Fred Please reply to newsgroup, not e-mail "Ron" wrote in message ... I need help converting Julian Date to regular calendar date. I have from 5000 - 10000 Julian Dates in one column. Ex. Col A need converted to 4001 = 1 Jan 04 5001 = 1 Jan 05 5030 = 30 Jan 05 Any help would be much appreciated. Thanks Ron -- Ron |
|
#3
|
|||
|
|||
|
Thank you Fred, sorry, but I don't understand, is it possible to expand you
explantion some. If I have 5000 Julian dates in column A how would I use your formula? Thanks -- Ron "Fred Smith" wrote: Use the formula =Date(int(a1/1000),1,mod(a1,1000)) -- Regards, Fred Please reply to newsgroup, not e-mail "Ron" wrote in message ... I need help converting Julian Date to regular calendar date. I have from 5000 - 10000 Julian Dates in one column. Ex. Col A need converted to 4001 = 1 Jan 04 5001 = 1 Jan 05 5030 = 30 Jan 05 Any help would be much appreciated. Thanks Ron -- Ron |
|
#4
|
|||
|
|||
|
Just some implementation assist ..
Assume data is in A1:A5000, Put in B1 (Fred's formula): =DATE(INT(A1/1000),1,MOD(A1,1000)) Format B1 as Custom, Type: d-mmm-yy Copy B1 down to B5000 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Ron" wrote in message ... Thank you Fred, sorry, but I don't understand, is it possible to expand you explantion some. If I have 5000 Julian dates in column A how would I use your formula? Thanks -- Ron |
|
#5
|
|||
|
|||
|
Thank your Max, you explained so even I got it to work! Thank YOU!
-- Ron "Max" wrote: Just some implementation assist .. Assume data is in A1:A5000, Put in B1 (Fred's formula): =DATE(INT(A1/1000),1,MOD(A1,1000)) Format B1 as Custom, Type: d-mmm-yy Copy B1 down to B5000 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Ron" wrote in message ... Thank you Fred, sorry, but I don't understand, is it possible to expand you explantion some. If I have 5000 Julian dates in column A how would I use your formula? Thanks -- Ron |
|
#6
|
|||
|
|||
|
Glad to hear that <g !
Thanks for the feedback .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Ron" wrote in message ... Thank your Max, you explained so even I got it to work! Thank YOU! -- Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert string to a date | Excel Worksheet Functions | |||
| extract numbers, convert to date | Excel Discussion (Misc queries) | |||
| Calendar and info for that date | Excel Discussion (Misc queries) | |||
| convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Linear Mode
