PDA

View Full Version : JULIAN dates



divingdingo
03-14-2008, 08:39 AM
hi

I have a spreadsheet with dates associated with each entry. unfortunately each date is in the JULIAN format but doesn't have a year assigned to it.
i.e it is 60, (not 00060 for march 01 2000)

i have the year associated with the JULIAN entry in another column.

is there any way of combining these two columns to produce a dd-mm-yy format entry.

kind thanks

mark

Bob Phillips
03-14-2008, 09:20 AM
In wnat way is 60 March 1st 2000 in the Julian calendar?

divingdingo
03-14-2008, 09:25 AM
In wnat way is 60 March 1st 2000 in the Julian calendar?

opps, i've just realised that whoever told me my data was in the JULIAN format, got it wrong and i'm really confused (not really a suprise if you knew me!)

okay so i have a column of sequential numbers that relates to the day of the year.

and a column of numbers which relates to the year.

ie

A B (the day they represent)
60 01 1 mar 01
61 01 2 mar 02
62 02 3 mar 02


etc

is there a way of combining these columns to get the format dd-mm-yy ??

thank you

a confused
mark

RonMcK
03-14-2008, 10:05 AM
is there a way of combining these columns to get the format dd-mm-yy ??
Mark,

How about this. Enter your sequential number in A2, enter 12/31/2007 (end of last year) in B2, and in C2 enter formula =A2+B2, pick your desired Date format.

If you want to convert the list of sequential numbers and see all the dates in the year, paste the list in A2:A367, and use the formula =A2+B$2 (copied from B2:B367)

Cheers!

Bob Phillips
03-14-2008, 10:49 AM
How about this

=DATE(2000+B1,1,A1)