# Julian Dates

#### jtswanny

##### New Member
Does anyone know how to convert a column of Julian date to Gregorian Dates...ie 2002002 to 1/2/02 or January 2, 2002.

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### Mark W.

##### MrExcel MVP
How 'bout...

=DATE(LEFT(A2,4),1,)+RIGHT(A2,3)

...where A2 contains your Julian date.

#### jtswanny

##### New Member
Thanks, You rock!! That saves me so much work...

#### dsmh7

##### New Member
For some reason this isn't working for me
I have the Julian date 03365 and the formula returns the date of 7/2/93. (the date should be 12/31/03 right?)

#### Mark W.

##### MrExcel MVP
dsmh7 said:
For some reason this isn't working for me
I have the Julian date 03365 and the formula returns the date of 7/2/93. (the date should be 12/31/03 right?)

What century is 03365 from? Why aren't you eliminating such ambiguity by using a yyyy date model?

If you want Excel to guess the century then use...

=("1/1/"&LEFT(A2,2))-1+RIGHT(A2,3)

Replies
4
Views
397
Replies
3
Views
372
Replies
3
Views
534
Replies
1
Views
269
Replies
17
Views
1K

1,195,849
Messages
6,011,953
Members
441,657
Latest member
Diupsy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back