How do I convert dd/mm/yy date format to yyddd Julian date format
If you are trying to get 02/08/1964 to show as 64Sat you could just change to
format of the cell to €śCustom€ť and set it as YYDDD.
If you want to convert it to the PC serial number set the formatting to
€śgeneral€ť and you will get the number of days from Jan 1, 1900 and the date
(assuming you are not using the 1904 date system).
If thats not what you are looking for give me a little more info. What is
the date in questions and what do you want it to look like as a result.
Hope that helps.
Frank
"itzy bitzy" wrote:
I have done this before, but can't remember how!
|