+ Reply to Thread
Results 1 to 5 of 5

Display a date in ="text "&A2

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Display a date in ="text "&A2

    Hi guys, is there a way to:

    ="Complete a goal by "&A2

    Where is A2 is a Date (currently set in a 31-Dec-18 format), so that end result would display as:

    Complete a goal by 31 Dec

    Is this possible for us?

    Thanking in advance!

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Display a date in ="text "&A2

    Yes, try this:

    ="Complete a goal by "&TEXT(A2,"dd mmm")

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Display a date in ="text "&A2

    If you want 01, for example, to show as 1, change dd to d. Double digit numbers will still show both digits.

  4. #4
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Display a date in ="text "&A2

    Perfect, 63falcondude, thank you!!!

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Display a date in ="text "&A2

    Happy to help. Thanks for the rep!

+ 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. Replies: 2
    Last Post: 03-22-2018, 06:34 AM
  2. [SOLVED] ContentControl Listbox - Get selected "Value" instead of "Display Text"
    By kev_ in forum Word Programming / VBA / Macros
    Replies: 9
    Last Post: 01-27-2017, 02:22 PM
  3. Replies: 4
    Last Post: 03-11-2016, 03:34 PM
  4. Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!
    By meus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2015, 09:56 AM
  5. Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!
    By meus in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2015, 06:14 AM
  6. Date format of just "st" "nd" "rd" and "th" with text included
    By notrandom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2013, 05:45 PM
  7. Replies: 1
    Last Post: 09-15-2010, 01:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1