Help to convert a date to julian date fromat yyyyddd in excel

Solved/Closed
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 - May 9, 2013 at 01:51 AM
 Calixte DORVIL - Sep 30, 2013 at 06:44 PM
hi,

i have thousands of dates in format dd-mm-yy that needs to be converted to julian date format yyyyddd. dates that needs to be converted are from period range of 01-may-13 to 31-dec-19. I am using MS excel for this purpose.
pls help me out to convert these dates to julian date with format yyyydd.

would realy appriciate your help in this regard..
Thanks...
May

4 responses

sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
May 9, 2013 at 09:05 AM
Hi

Then Try this Formula

=RIGHT(YEAR(A2),4)&TEXT(A2-DATE(YEAR(A2),1,0),"000")

Hope it will solve your problem, other wise please inform

we will wait for your response

Thanks


Patnaik
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 5
May 27, 2013 at 03:47 AM
great it works..

Thank You
0