View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How do I convert a julian date to a regular date?

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

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"tamtec99" wrote in message
...
I need the formula to convert numbers to a standard date format. Some
examples are as follows: 16330
22364
19215
19206
24273
17030
24277
20240
27289
21183
26284
27246