View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robin watersong robin watersong is offline
external usenet poster
 
Posts: 1
Default how to convert from julian date to mm/dd/year

My data was originally in accounting system as standard date but when I have
to query database (using MicroSoft Access), the data results for dates have
been converted to julian. I cannot find my old formula to allow me to
convert julian dates back into standard date format such as mm/dd/yr. Can
anyone please help?

Thank you,
Robin