julian date

Tian · Jun 5, 2004

Hi, can someone help with a formula to change julian date like 104156 to 06/04/2004? Thanks very much

Gord Dibben · Jun 5, 2004

Tian

Chip Pearson can help you. See his site for formulas converting to and from
Julian dates.

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

Gord Dibben Excel MVP