Julian Date
 

Hi, I try to convert the Julian date and that' not work. I try from formulas
that was on the site but these just not work and give me #NOM? as a result.
Here is an ememple of the date I need to convert : 107064. It should be the
day 64 of 2007.
Thanks for your help !

Julian Date
 

Sorry everyone, I just found out that the issue was because my computer was
in French and not in Englist, so the formulas need to be translate in French.

Also since I use a 6 letter Julian date, I change something in the formulas.
Here is what I used :

DATE(SI(0+(GAUCHE(F2,2))<30,2000,1900)+STXT(F3,2,2 ),1,DROITE(F2,3))

Tks

"Martin" wrote:

Hi, I try to convert the Julian date and that' not work. I try from formulas
that was on the site but these just not work and give me #NOM? as a result.
Here is an ememple of the date I need to convert : 107064. It should be the
day 64 of 2007.
Thanks for your help !