Results 1 to 9 of 9

How to convert a manufacturing Lot Number to a date

Threaded View

  1. 07-17-2018, 01:01 PM #1
    jalcocer1990
    jalcocer1990 is offline
    Registered User
    Join Date
    07-17-2018
    Location
    California
    MS-Off Ver
    Excel
    Posts
    4

    How to convert a manufacturing Lot Number to a date

    I'm trying to convert Manufacturing Lot # 03180940702 to April 04 2018 in any format date. The numbers to read off of this are as follows

    03
    18 - year (2018)
    094 julian date (April 04 2018)
    0702

    Does anyone know what formula I can use?
    Last edited by jalcocer1990; 07-17-2018 at 03:07 PM. Reason: correction a typo in lot #
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to get number of calendar days per number of manufacturing days
    By marcella needs help in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-06-2017, 05:51 PM
  2. [SOLVED] Total units made by week number with varying manufacturing periods
    By BRISBANEBOB in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2016, 06:49 PM
  3. [SOLVED] Convert a Text String Date to Date Serial Number
    By herve73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2015, 10:53 AM
  4. how to convert date serial number to regular date?
    By union in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2013, 10:15 PM
  5. how to convert number to date
    By sunwordelite in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2009, 03:47 PM
  6. convert date number to date format
    By nygwnj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2007, 02:15 PM
  7. How do I convert Date serial number to date
    By rdunne in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1