how to convert julian date to general date

arkprabha · Apr 3, 2006

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

Gary''s Student · Apr 3, 2006

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

Format as Custom, Type: d-mmm-yy