+ Reply to Thread
Results 1 to 4 of 4

Auto Generate an ID# based on date

  1. #1
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Auto Generate an ID# based on date

    HI all,

    I'm working on a spreadsheet where I want to auto generate an ID# based on the date. For instance... In Column A, I input the date the data was entered, In column B, I want an ID# that reflects the date and the sequence of entries for that day, ie. 161013-1 or 1610131 and if there were another entry for that day 161013-2. If there were any entries the following day it would start back at 1, 161014-1

    Thanks for any help you're able to provide.

    Jamie
    Last edited by jme1013; 10-13-2016 at 11:36 AM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,914

    Re: Auto Generate an ID# based on date

    Try this ...

    =TEXT(A1,"YYMMDD")&"-"&COUNTIF($A$1:A1,A1)

    Copy down.

  3. #3
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Re: Auto Generate an ID# based on date

    That worked simply and perfectly. Thank you very much.

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,914

    Re: Auto Generate an ID# based on date

    You are welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto-Generate 'record' number based on date
    By russkris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2015, 12:23 AM
  2. [SOLVED] Generate request id with date and auto number
    By star18 in forum Excel General
    Replies: 6
    Last Post: 01-06-2014, 09:19 PM
  3. Macro to auto-generate a hyperlink based on value
    By Biased Historian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2011, 07:37 PM
  4. Auto-Generate Due Date based on Ship Date, and other things
    By cjmorin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-18-2011, 02:51 PM
  5. auto generate based on percentage?
    By tondrey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2010, 03:38 PM
  6. formula to generate month-to-date based on auto date
    By infinitysales in forum Excel General
    Replies: 1
    Last Post: 06-27-2008, 01:09 AM
  7. Auto Generate a Grade based on a percent
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 11-01-2007, 01:35 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1