+ Reply to Thread
Results 1 to 7 of 7

Assistance with manipulating Dates into text

  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Assistance with manipulating Dates into text

    I have dates in Column A, in column B I would like to have it check the table C1:E12 (using vlookup if needed) for column A's date. Then when it finds it, show me whats in Column C (Ex: Jan)

    Example:
    Column A1:A100 all show a date.
    Column B: (Hoping to say Ex: Jan)

    Column C1,D1 and E1 and down shows this
    Jan 12-26-14 01-25-16
    Feb 01-26-16 02-25-16
    Mar 02-26-16 03-25-16
    Apr 03-26-16 04-25-16
    May 04-26-16 05-25-16
    etc

  2. #2
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Re: Assistance with manipulating Dates into text

    so you are matching column A against column C or D to return the relative value in B?

    or am i misunderstanding what you want.

    Please attach a sample file instead of text if that is not the case. Be sure to clearly illustrate your question.

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Assistance with manipulating Dates into text

    Try

    =LOOKUP(A1,D$1:D$100,C$1:C$100)

  4. #4
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Re: Assistance with manipulating Dates into text

    Attached is a Demo
    Attached Files Attached Files

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Assistance with manipulating Dates into text

    I think you may have attached the wrong file
    I see nothing in that file that looks even remotely close to your description in original post.

  6. #6
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Re: Assistance with manipulating Dates into text

    That did it Jonmo1.
    Thank you. I've never used the Lookup function before. Good to know about that now. Thanks

  7. #7
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Assistance with manipulating Dates into text

    You're 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] Macro assistance to identify dates in one range and place text in a cell in worksheets
    By lilsnoop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2013, 12:29 PM
  2. Manipulating intake & discharge dates, counting between dates
    By lisast in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-02-2013, 03:59 AM
  3. Manipulating dates outputs with criteria
    By stpetece in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2011, 04:13 PM
  4. Manipulating Dates and Format
    By pdiminski in forum Excel General
    Replies: 4
    Last Post: 03-07-2010, 03:55 PM
  5. Manipulating Text
    By John Vieren in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-03-2009, 08:32 AM
  6. Need Assistance Manipulating a file.
    By Fenerbahce in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2008, 12:34 AM
  7. [SOLVED] Re: Manipulating dates (was Add 6 months to a date)
    By Bill Ridgeway in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-31-2006, 02:50 PM
  8. Manipulating text of an equation
    By achidsey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 07:06 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