Start with Chip Pearson's website and post back if you have more questions:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Robert" wrote:

how do I convert a julian gregorian date code into a regular date. I have a
julian gregorian (1582) date code that I want to convert into a regular
month/day/year code. How do I do this? Is there a formula for this? Here
is a sample date code: 2453523.