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

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

    software

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

    E-mail轉寄