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
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
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" <[email protected]> wrote in message
news:[email protected]...
>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
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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks