Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to work with serial number dates and Julian dates in Excel 2000
Article ID: 214099 - View products that this article applies to.
This article was previously published under Q214099
This article explains how to convert serial number dates to "Julian dates" and how to convert Julian dates to serial number dates in Microsoft Excel 2000. Julian dates refer to the number of days from the first of the year and the number of days until the end of the year as printed on most desktop calendars.
Many government agencies and contractors require the use of Julian dates.
Examples of Julian DatesThe following are examples of Julian dates:
Date Julian date ------------------------- Jan-01-1999 99001 Jan-10-1999 99010
where Standard_Date is the defined name that you gave to the cell that contains the date to be converted. You must enter the entire formula in a single cell.