convert Julian date

D

Doug

I would like to know if there is a function to convert a Julian date (04365)
to a regular date (31 Jan 04). If so, please post! Thank You

Doug
 
R

Ron Coderre

Try pointing this formula at your Julian Date:
I used Cell A1:
=DATE(1999+QUOTIENT(A1,1000),12,31)+MOD(A1,1000)

Does that help?
 
R

Ron

I used the following to convert JD:
=DATE(INT(B5/1000),1,MOD(B5,1000) with first cell of data being B5.
 

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

How do I get the date to display a Julian date? (yyddd) 2
Use excel to calculate an expiration date 1
Convert a julian gregorian date code into a regular date 3
to convert a julian date back to regular date 1
How to use/create code in MS Word to calculate age? 0
Difficulty with compatibility mode and Track Changes 2
Word- Find and Replace 1
Convert Date to Julian Date 2

Top