Help to convert a date to julian date fromat yyyyddd in excel Solved/Closed

Question

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

sgmpatnaik · Accepted Answer

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

sgmpatnaik · Answer

@seekermay

HI

Please Try the below formula

say your date stored in the Column A2:A then type the Formula in Column B

=TEXT($A2,"YYYY")&" - "&TEXT($A2,"DD")

with the above formula you will get the date as

01-05-2013

with my formula

2013 - 01

Hope it will solve your problem, other wise please inform us

Thanks

Patnaik

seekermay · Answer

thank you for reply.

i think I have mis interpretted above. now trying to explain it as simple as to convert the date as per below example.

From date format:                            09-May-13
To be converted to julian date as:   2013129
 
would appriciate your help once again and accept my apoogy for inconvenience.

regards...may

Kevin@Radstock · Answer

Here you go seekermay, some reading for you regarding Julian dates.


http://www.cpearson.com/excel/jdates.htm

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

4 responses

Similar discussions

Subscribe To Our Newsletter!