Tip of the Day | Friday July 26th, 2024
Discover new tools to get things done.
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, 2021 is represented as 2021001 and December 31, 2021 is represented as 2021365. 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).
Screenshots
Starting this tool
- Click ASAP Utilities › Numbers & Dates › 16. Change Julian dates to normal dates
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years