Results 1 to 7 of 7

Customize Date field to inlcude additional data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-10-2014
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20368) 64-bit
    Posts
    101

    Customize Date field to inlcude additional data

    Hello,

    I am looking to see if there is a way to modify a date column that is already in a cell and then include a (1) or (2) next to it. I have included my workbook and if you look at it, you will see that column D includes the date that I want to use and then I would like to use the last integer over in column G (ex: DivSemiFinals1) I would like to use the one and have the value turn out as (1). So the first line would have the value in column D to show it as 04/04/84 (1).

    If possible, I would like this to be applied on all worksheets within my workbook referring to columns D and G. If anyone could let me know how this can get done I would appreciate it. Thanks in advance for your help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding additional field to pivot table (but not for each column)
    By cprobertson1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-21-2017, 07:51 AM
  2. [SOLVED] PowerPivot: Merge Month Field and Year Field Into a Date Field
    By mo4391 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-17-2015, 11:59 AM
  3. [SOLVED] Amend VBA code to Inlcude PasteValues
    By ShakJames in forum Excel General
    Replies: 2
    Last Post: 02-23-2015, 10:31 AM
  4. Additional Field Added after Macro is Run
    By kelz_dunks4life in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2014, 05:18 PM
  5. Macro to run on the additional field
    By Deepa12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2013, 09:06 PM
  6. Extract a date from a field and append another field's data
    By Leroy221 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2012, 11:35 AM
  7. Pivot Table Customize functions in the Data Field
    By PSKelligan in forum Excel General
    Replies: 2
    Last Post: 01-04-2005, 03:06 PM

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