ExcelBanter - convert Julian date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - convert Julian date (https://www.excelbanter.com/excel-worksheet-functions/25004-convert-julian-date.html)

Doug

convert Julian date

I would like to know if there is a function to convert a Julian date (04365)
to a regular date (31 Jan 04). If so, please post! Thank You

Doug

Niek Otten

Hi Doug,

http://www.cpearson.com/excel/jdates.htm

But are you sure it isn't 31 Dec 04?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Doug" wrote in message
...
I would like to know if there is a function to convert a Julian date
(04365)
to a regular date (31 Jan 04). If so, please post! Thank You

Doug

Ron Coderre

Try pointing this formula at your Julian Date:
I used Cell A1:
=DATE(1999+QUOTIENT(A1,1000),12,31)+MOD(A1,1000)

Does that help?
--
Regards,
Ron

Ron

I used the following to convert JD:
=DATE(INT(B5/1000),1,MOD(B5,1000) with first cell of data being B5.
--
Ron

"Ron Coderre" wrote:

Try pointing this formula at your Julian Date:
I used Cell A1:
=DATE(1999+QUOTIENT(A1,1000),12,31)+MOD(A1,1000)

Does that help?
--
Regards,
Ron

All times are GMT +1. The time now is 10:11 AM.