{"id":10147,"date":"2022-06-22T08:04:13","date_gmt":"2022-06-22T08:04:13","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=10147"},"modified":"2024-03-26T11:06:24","modified_gmt":"2024-03-26T11:06:24","slug":"convert-julian-date-to-calendar-date","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/","title":{"rendered":"Convert Julian Date to Calendar Date in Excel"},"content":{"rendered":"\n

The Julian <\/strong>date format uses the combination of a year and the number of elapsed days of the year.<\/p>\n\n\n\n

Julian dates<\/strong> are mostly used by manufacturers of products such as electronic products, pharmaceutical products, and food products as timestamps<\/strong> and batch reference numbers<\/strong>. They are also used in the military, astronomy, and programming.<\/p>\n\n\n\n

Different manufacturers and organizations have their variations on Julian dates<\/strong>. For this tutorial, we will use the variation that uses 7 digits: the first four digits represent the year and the last three digits represent the total number of elapsed days in the year. For example, the Julian date for 1\/1\/1980<\/strong> would be 1980001<\/strong> and the Julian date for 31\/12\/2020 <\/strong>would be 2020366<\/strong>.<\/p>\n\n\n\n

Consumers, service agents, or retailers can use the Julian dates from manufacturers to identify the manufacturing date of a product and thus the age of the product. Julian dates however cannot be used in calculations involving dates in Excel hence the need to first convert them into standard Calendar dates.<\/p>\n\n\n\n

Three methods of converting Julian dates to standard Calendar dates<\/h2>\n\n\n\n

In this tutorial we will learn the following three methods of converting the 7-digit Julian dates to standard calendar dates in Excel:<\/p>\n\n\n\n

    \n
  1. Use the combination of DATE, LEFT, and RIGHT functions<\/strong>.<\/li>\n\n\n\n
  2. Use the combination of DATE, MOD, and INT functions<\/strong>.<\/li>\n\n\n\n
  3. Use User Defined Function<\/strong>.<\/li>\n<\/ol>\n\n\n\n

    We will use the following dataset to show how the three methods can be used to convert Julian dates to standard Calendar dates:<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Method 1 – Use the combination of DATE, LEFT, and RIGHT functions.<\/h2>\n\n\n\n

    In this method, we use the combination of DATE, LEFT, and RIGHT functions <\/strong>to convert Julian dates <\/strong>to Calendar dates<\/strong><\/p>\n\n\n\n

    The DATE<\/strong> function returns the number that represents the date in the Microsoft Excel date-time code<\/strong>. It takes three arguments and its syntax is DATE(year, month, day)<\/strong>.<\/p>\n\n\n\n

    The LEFT<\/strong> function returns the specified number of characters from the start of a text string. It takes two arguments and its syntax is LEFT(text, [num_chars])<\/strong>. The num_char<\/strong> argument is optional and if it is not supplied, the LEFT<\/strong> function returns only the first character of the given text string.<\/p>\n\n\n\n

    The RIGHT<\/strong> function returns the specified number of characters from the end of a text string. It takes two arguments and its syntax is RIGHT(text, [num_chars])<\/strong>. The num_char<\/strong> argument is optional and if it is not supplied, the RIGHT<\/strong> function returns only the last character of the given text string.<\/p>\n\n\n\n

    We use the following steps to generate Calendar dates from Julian dates:<\/p>\n\n\n\n

      \n
    1. Select Cell C2<\/strong> and type in the formula:<\/li>\n<\/ol>\n\n\n\n
       =DATE(LEFT(B2,4),1,RIGHT(B2,3))<\/code><\/pre>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
        \n
      1. Press the Enter key and double-click or drag down the fill handle<\/strong> to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        All the Julian dates<\/strong> in Column B are converted to standard calendar dates<\/strong> in Column C.<\/p>\n\n\n\n
        Explanation of the formula<\/strong><\/p>\n\n\n\n
        =DATE(LEFT(B2,4),1,RIGHT(B2,3))<\/code><\/pre>\n\n\n\n
        The LEFT<\/strong> function returns 4<\/strong> characters of the value in cell B2<\/strong> and the RIGHT<\/strong> function returns 3<\/strong> characters.<\/p>\n\n\n\n
        In this case, the formula then becomes =DATE(2020,1,366). Although we supplied the value 1<\/strong> for the month argument, the DATE<\/strong> function used the number of elapsed days in the year (366) to calculate the correct month and give the correct calendar date of 31\/12\/2020<\/strong>.<\/p>\n\n\n\n
        Method 2 – Use the combination of DATE, MOD, and INT functions<\/h2>\n\n\n\n
        In this method, we use the combination of DATE, MOD, and INT functions<\/strong> to convert Julian dates to Calendar dates.<\/p>\n\n\n\n
        The DATE<\/strong> function returns the number that represents the date in the Microsoft Excel date-time code<\/strong>. It takes three arguments and its syntax is DATE(year, month, day)<\/strong>.<\/p>\n\n\n\n
        The MOD<\/strong> function returns the remainder<\/strong> after a number is divided by a divisor. It takes two arguments and its syntax is MOD(number, divisor)<\/strong>.<\/p>\n\n\n\n
        The INT<\/strong> function rounds a number down<\/strong> to the nearest integer<\/strong>. It takes only one argument and its syntax is INT(number)<\/strong>.<\/p>\n\n\n\n
        We use the following steps in this method:<\/p>\n\n\n\n
          \n
        1. Select cell C2<\/strong> and type in the formula:<\/li>\n<\/ol>\n\n\n\n
          =DATE(INT(B2\/10^3),1,MOD(B2,INT(B2\/10^3)))<\/code><\/pre>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
            \n
          1. Press the Enter key and drag down the Fill Handle to copy the formula<\/a> down the column:<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            The Julian dates<\/strong> in Column B are converted to standard Calendar dates<\/strong> in Column C.<\/p>\n\n\n\n
            Explanation of the formula<\/strong><\/p>\n\n\n\n
            =DATE(INT(B2\/10^3),1,MOD(B2,INT(B2\/10^3)))<\/code><\/pre>\n\n\n\n
              \n
            • INT(B2\/10^3). To generate a value for the first argument of the DATE function, we divide the value 2020366<\/strong> in Cell B2 by 1000<\/strong> because we want to extract only the first four digits that represent the year. This results in 2020.366<\/strong>. The INT<\/strong> function rounds this decimal number down to the nearest integer and it becomes 2020<\/strong>. <\/li>\n\n\n\n
            • MOD(B2,INT(B2\/10^3)). To generate a value for the third argument of the DATE<\/strong> function we plug in the number from the previous step into this part of the formula and it becomes MOD(2020366,2020). The MOD<\/strong> function then returns the remainder value of 366<\/strong>.<\/li>\n\n\n\n
            • =DATE(INT(B2\/10^3),1,MOD(B2,INT(B2\/10^3))) becomes =DATE(2020,1,366) and the DATE<\/strong> function returns the Calendar date of 31\/12\/2020. Although the value 1<\/strong> is the second argument, the DATE<\/strong> function uses the number of elapsed days in the year (366) to compute the correct month.<\/li>\n<\/ul>\n\n\n\n
              Method 3 – Use a User Defined Function<\/h2>\n\n\n\n
              We can also use Excel VBA<\/strong> to create a User Defined Function<\/strong> that we can use to convert Julian dates to standard Calendar dates using the following steps:<\/p>\n\n\n\n
                \n
              1. In the active worksheet press Alt + F11<\/strong> to switch to the Visual Basic Editor<\/strong>. Alternatively, we can choose Developer >> Code >> Visual Basic<\/strong> on the Excel Ribbon<\/strong>:<\/li>\n<\/ol>\n\n\n\n
                \"\"<\/figure>\n\n\n\n
                  \n
                1. Right-click on the workbook in the Project Window<\/strong> and insert a new module:<\/li>\n<\/ol>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n
                    \n
                  1. In the new module type in the following JUDtoCAD<\/strong> (Julian Date to Calendar Date) function procedure:<\/strong><\/li>\n<\/ol>\n\n\n\n
                    Function JUDtoCAD(JUD As String) As Long\n    Dim Year As Integer\n    Dim Day As Integer\n    Dim CAD As Long\n    Year = CInt(Left(JUD, 4))\n    Day = CInt(Right(JUD, 3))\n    CAD = DateSerial(Year, 1, Day)\n    JUDtoCAD = CAD\nEnd Function<\/code><\/pre>\n\n\n\n
                      \n
                    1. Save the module and save the workbook as a macro-enabled workbook<\/strong>.<\/li>\n\n\n\n
                    2. Press Alt + F11<\/strong> to switch back to the active worksheet. Alternatively, we can click on the View Microsoft Excel<\/strong> button on the toolbar:<\/li>\n<\/ol>\n\n\n\n
                      \"\"<\/figure>\n\n\n\n
                        \n
                      1. Select cell C2<\/strong> and type in the formula =JUDtoCAD(B2) as follows:<\/li>\n<\/ol>\n\n\n\n
                        \"\"<\/figure>\n\n\n\n
                          \n
                        1. Press the Enter key and double-click or drag down the fill handle<\/strong> to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          The Julian dates<\/strong> in Column B are converted to standard Calendar dates<\/strong> in Column C.<\/p>\n\n\n\n
                          Explanation of the JUDtoCAD User Defined Function<\/strong><\/p>\n\n\n\n
                          Function JUDtoCAD(JUD As String) As Long\n    Dim Year As Integer\n    Dim Day As Integer\n    Dim CAD As Long\n    Year = CInt(Left(JUD, 4))\n    Day = CInt(Right(JUD, 3))\n    CAD = DateSerial(Year, 1, Day)\n    JUDtoCAD = CAD\nEnd Function\n<\/code><\/pre>\n\n\n\n
                            \n
                          • Function JUDtoCAD(JUD As String) As Long.  The name of the function is JUDtoCAD and its data type is Long<\/strong>. It takes one argument of string data type.<\/li>\n\n\n\n
                          • Three variables are declared: Year<\/strong> of Integer data type<\/strong>, Day<\/strong> of Integer data type<\/strong>, and CAD<\/strong> of Long data type<\/strong>.<\/li>\n\n\n\n
                          • Year = CInt(Left(JUD, 4)). The Left<\/strong> VBA in-built function returns four characters from the start of the JUD text string that is passed to it. The in-built CInt<\/strong> function converts the four characters into an integer value and assigns it to the Year<\/strong> variable.<\/li>\n\n\n\n
                          • Day = CInt(Right(JUD, 3)). The Right<\/strong> VBA in-built function returns three characters from the end of the JUD text string that is passed to it. The in-built CInt<\/strong> function converts the three characters into an integer value and assigns it to the Day<\/strong> variable.<\/li>\n\n\n\n
                          • CAD = DateSerial(Year, 1, Day). The DateSerial<\/strong> function returns a date for the specified year, month, and day.<\/li>\n\n\n\n
                          • JUDtoCAD = CAD. The date value returned by the DateSerial<\/strong> function is assigned to the JUDtoCAD<\/strong> variable, and it is the date returned when we run the JUDtoCAD function.<\/li>\n<\/ul>\n\n\n\n
                            Conclusion<\/h2>\n\n\n\n
                            In this tutorial, we explained that a Julian date<\/strong> format is the date format that uses the combination of the year and the number of elapsed days in the year.<\/p>\n\n\n\n
                            The Julian dates are mostly used in manufacturing environments as timestamps<\/strong> and as batch reference numbers<\/strong>. Dates in this format however cannot be used for calculations involving dates in Excel hence the need to convert them into standard Calendar dates.<\/p>\n\n\n\n
                            We looked at three methods that we can use to convert Julian<\/strong> dates into standard Calendar<\/strong> dates:  use the combination of DATE, LEFT, and RIGHT functions, <\/strong>use the combination of DATE, MOD, and INT functions, <\/strong>and employ the use of a User Defined Function<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"
                            The Julian date format uses the combination of a year and the number of elapsed days of the year. Julian dates are mostly…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"\nConvert Julian Date to Calendar Date in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to convert Julian dates to standard Calendar dates in Excel with three easy-to-follow methods. Perfect for identifying manufacturing dates!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert Julian Date to Calendar Date in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to convert Julian dates to standard Calendar dates in Excel with three easy-to-follow methods. Perfect for identifying manufacturing dates!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-22T08:04:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T11:06:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Convert Julian Date to Calendar Date in Excel\",\"datePublished\":\"2022-06-22T08:04:13+00:00\",\"dateModified\":\"2024-03-26T11:06:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/\"},\"wordCount\":1306,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/\",\"name\":\"Convert Julian Date to Calendar Date in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png\",\"datePublished\":\"2022-06-22T08:04:13+00:00\",\"dateModified\":\"2024-03-26T11:06:24+00:00\",\"description\":\"Learn how to convert Julian dates to standard Calendar dates in Excel with three easy-to-follow methods. Perfect for identifying manufacturing dates!\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png\",\"width\":549,\"height\":159},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert Julian Date to Calendar Date in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert Julian Date to Calendar Date in Excel","description":"Learn how to convert Julian dates to standard Calendar dates in Excel with three easy-to-follow methods. Perfect for identifying manufacturing dates!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/","og_locale":"en_US","og_type":"article","og_title":"Convert Julian Date to Calendar Date in Excel","og_description":"Learn how to convert Julian dates to standard Calendar dates in Excel with three easy-to-follow methods. Perfect for identifying manufacturing dates!","og_url":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/","article_published_time":"2022-06-22T08:04:13+00:00","article_modified_time":"2024-03-26T11:06:24+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Convert Julian Date to Calendar Date in Excel","datePublished":"2022-06-22T08:04:13+00:00","dateModified":"2024-03-26T11:06:24+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/"},"wordCount":1306,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/","url":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/","name":"Convert Julian Date to Calendar Date in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png","datePublished":"2022-06-22T08:04:13+00:00","dateModified":"2024-03-26T11:06:24+00:00","description":"Learn how to convert Julian dates to standard Calendar dates in Excel with three easy-to-follow methods. Perfect for identifying manufacturing dates!","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/products-list.png","width":549,"height":159},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-julian-date-to-calendar-date\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Convert Julian Date to Calendar Date in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10147"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=10147"}],"version-history":[{"count":10,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10147\/revisions"}],"predecessor-version":[{"id":15780,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10147\/revisions\/15780"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=10147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=10147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=10147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}