HI,

How do i convert yyyy-mm-dd date format in to a julian date? can somebody
help? Thanks

See Chip Pearson's website:

http://www.cpearson.com/excel/jdates.htm

Does that help?
***********
Regards,
Ron

XL2002, WinXP-Pro


"nick" wrote:

HI,

How do i convert yyyy-mm-dd date format in to a julian date? can somebody
help? Thanks

With your yyyy-mm-dd date in Excel-readable format in cell A1, this
formula will do it:
=YEAR(A1)&A1-DATE(YEAR(A1),1,1)

Thanks a lot to both of you. it worked!

"Dave O" wrote:

With your yyyy-mm-dd date in Excel-readable format in cell A1, this
formula will do it:
=YEAR(A1)&A1-DATE(YEAR(A1),1,1)