Results 1 to 2 of 2

Thread: Serial number to date formula

  1. #1
    Junior Member
    Join Date
    Jan 2017
    Posts
    1
    Rep Power
    0

    Serial number to date formula

    I have a set of serial numbers and individually i can easily obtain the year and month of product for them. However, I have a rather long list and would like to make it easier. The serial numbers start as W0A1*********. The 01 is the year and the A is the month (in this case Jan). Is there a code I can use to pull this information automatically in excel 2013?

  2. #2
    Member
    Join Date
    May 2013
    Posts
    31
    Rep Power
    0
    Welcome to the forum!

    Did you want a formula or VBA? Mid() would be used in both. Where is the day in that or is day 1 sufficient?

    Click the Go Advanced button in lower right of a reply, and scroll down to Manage Attachments to browse and upload a file if needed.

Similar Threads

  1. convert formula to a number
    By galang_ofel in forum Excel Help
    Replies: 5
    Last Post: 03-23-2015, 10:49 AM
  2. Data Validation For Selecting Date And Week Number
    By paul_pearson in forum Excel Help
    Replies: 8
    Last Post: 06-16-2013, 05:07 AM
  3. Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  4. Replies: 17
    Last Post: 12-18-2012, 04:15 PM
  5. Number 9.99999999E+307 in Excel Formula
    By Admin in forum Familiar with Commands and Formulas
    Replies: 0
    Last Post: 06-11-2012, 04:09 PM

Posting Permissions

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