logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Numbers & Dates » Change Julian dates to normal dates

This tool will convert Julian dates to normal dates.

A Julian date is sometimes used in the computer industry to refer to a date format that is a combination of the current year and the number of days since the beginning of the year. For example, January 1, 2011 is represented as 2011001 and December 31, 2011 is represented as 2011365. Note that this format is not based on the Julian calendar.

Besides the yyddd and yyyyddd the JD Edwards (AS/400) cyyddd format is also supported by this tool. Their system adds a 0 or 1 in front of the year representing the century (0 = 1900, 1 = 2000, Jan 15, 1910 is 010015, Jan 15, 2010 is 110015).


Numbers & Dates » Change Julian dates to normal dates

Starting this utility

In the Excel menu choose: ASAP Utilities » Numbers & Dates » Change Julian dates to normal dates

« Return to the list of “Numbers & Dates” tools.
« Previous
Convert/recognize dates...
 Next »
Insert before and/or after each cell in your selection...
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utilities
Additional keywords for this tool:
Julian calendar, day, year, chronology, Ordinal Date, the number of the day in a particular year, ISO8601:2000(E)

Follow ASAP Utilities on Facebook

Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2018 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook