how to convert julian date to general date

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 Student


"arkprabha" wrote:

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