how to convert julian date to general date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moon phases and julian dates 0
Convert a julian gregorian date code into a regular date 3
How do I convert Julian date to fiscal date 1
Converting a date to a text field w/o converting it to a julian da 2
How do I convert from a julian date to a standard date mm/dd/yyy 3
to convert a julian date back to regular date 1
Convert Dates 12
JULIAN DATES? 8

Back
Top