Thread
:
how to convert from julian date to mm/dd/year
View Single Post
#
5
Posted to microsoft.public.excel.misc
robin watersong[_2_]
external usenet poster
Posts: 3
how to convert from julian date to mm/dd/year
Thank you Martin...saved me much dusting of the brain cells where the Excel
tricks are stored...especially when the project is due Monday AM!
"MartinW" wrote:
Hi Robin,
Chip Pearson explains it here.
http://www.cpearson.com/excel/jdates.htm
HTH
Martin
"robin watersong" <robin
wrote in
message ...
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
Reply With Quote
robin watersong[_2_]
View Public Profile
Find all posts by robin watersong[_2_]