How to Convert a Julian Date to Calendar Date
 

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

How to Convert a Julian Date to Calendar Date
 

http://www.cpearson.com/excel/jdates.htm
--
Gary''s Student - gsnu200760

How to Convert a Julian Date to Calendar Date
 

http://www.cpearson.com/excel/jdates.htm


--


Regards,


Peo Sjoblom


"Rob Phillips" <Rob wrote in message
...
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