Thread
:
how to convert from julian date to mm/dd/year
View Single Post
#
3
Posted to microsoft.public.excel.misc
MartinW
external usenet poster
Posts: 860
how to convert from julian date to mm/dd/year
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
MartinW
View Public Profile
Find all posts by MartinW