View Single Post
  #1   Report Post  
Jessica
 
Posts: n/a
Default How do I convert a Julian date into a regular date?

I have a long list of Julian dates that are formatted as follows:
3300
1296
0346

The first number is the year, i.e. 2003, 2001, 2000.
The next three numbers are the numeric equivalent of where that date falls
in the year, i.e. 300=Oct 27, 296=Oct 23, and 346=Dec 12.

Excel talks about how to convert to a Julian date, but I have not found how
to go from a Julian date to a regular date that I am used to seeing.

Many thanks,

Jessica Nelson