Julian date formatting

[glbellpru]

Hi Folks,

I have a file of transactions with attaching dates in a Julian format

The dates start at b2, b3, b4 etc....

The format is as follows:- 19851021 (i.e. 21 March 1985)

I need some way of translating this into a dd/mm/yyyy fomat so I can build some lookups formulas.

Any help is great !

GB

 

[Zack Barresse]

check out cpearson's website explanation.

HTH

 

[glbellpru]

Folks,

This website formula doesnt work for me due to :-

"...in the Julian format, which is a 5 digit number, consisting of a 2 digit year and a 3 digit day-of-year number.."

I have an 8 digit format (yyyymmdd)

Any ideas here

cheers

 

[Andrew Poulsom]

If A1 contains 19851021 this formula:

=TEXT(A1,"0000-00-00")+0

will convert it to a serial date - 21st October 1985 (not March as you posted).