How to Convert a Julian Date to Calendar Date

R

Rob Phillips

How do I Convert a Julian Date to Calendar Date?

Examples: 7365 = 12/31/07

The first number represents the Year and the next 3 numbers are the days of
that year. What formula would I type to get this. Also If I wanted to
subtract the julian date to find out (example when a product will expire)
(7365 - todays date - 180 days = ?) .........(The result would be desired in
this format 06/21/08) Please help!

Please email me with answers at (e-mail address removed)
 

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

Change satellite julian date format YYYYDDDHHMMSS to excel date ti 1
convert Julian date to DD/MM/YYYY 7
how to convert from julian date to mm/dd/year 6
convert Julian Date Format to Excel 1
convert julian date to calendar date in excel 2
convert julian date to gregorian date 1
Julian Calendar 1
How do I convert a Julian date into a regular date? 4

Top