close

i want to convert my past julian date into general date format. pls ans me asap

=DATE(INT(A1/1000),1,MOD(A1,1000))

Format as Custom, Type: d-mmm-yy

--
Gary's Studentquot;arkprabhaquot; wrote:

gt; i want to convert my past julian date into general date format. pls ans me asap

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄