close
HI,
How do i convert yyyy-mm-dd date format in to a julian date? can somebody
help? Thanks
See Chip Pearson's website:
www.cpearson.com/excel/jdates.htm
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Proquot;nickquot; wrote:
gt; HI,
gt;
gt; How do i convert yyyy-mm-dd date format in to a julian date? can somebody
gt; help? Thanks
With your yyyy-mm-dd date in Excel-readable format in cell A1, this
formula will do it:
=YEAR(A1)amp;A1-DATE(YEAR(A1),1,1)Thanks a lot to both of you. it worked!
quot;Dave Oquot; wrote:
gt; With your yyyy-mm-dd date in Excel-readable format in cell A1, this
gt; formula will do it:
gt; =YEAR(A1)amp;A1-DATE(YEAR(A1),1,1)
gt;
gt;
全站熱搜
留言列表
