+ Reply to Thread
Results 1 to 5 of 5

Combining text and the TODAY function help

  1. #1
    Registered User
    Join Date
    12-05-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    7

    Combining text and the TODAY function help

    Hello people I am in need of assistance in trying to complete the following formula.

    The formula is to consist of text at the start an example been "hello world " then I wanted it to have a space then today's date showing.

    I did the following formula ="Hello World " & TODAY() thinking that would be enough but instead I get the following result

    Hello World 41933 I know that the numbers is due to excel calculating the date in it's own method.
    The question I need answering is how do I do it so that instead of the above it comes out as Hello World 21/10/2014.

    Any advice would be grateful and thanks

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Combining text and the TODAY function help

    Try this:
    ="Hello World "&TEXT(TODAY(),"DD/MM/YYYY")
    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    12-05-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Combining text and the TODAY function help

    Thanks that did help sorry to bother you again.
    Is there anyway of having the above code but adding a day to the date that is on the computer so the 21/10/2014 would come up as 22/10/2014.
    Thanks again

  4. #4
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: Combining text and the TODAY function help

    add +1 to the formula?

  5. #5
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Combining text and the TODAY function help

    Sorry for the delay...(real job interference)

    Try this:
    Please Login or Register  to view this content.
    Is that something you can work with?

+ 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: 10
    Last Post: 09-06-2023, 08:19 PM
  2. [SOLVED] Combining Text Function with Indirect Function
    By ninmjj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2013, 10:34 AM
  3. TODAY() function to text
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2009, 10:30 AM
  4. Using text and TODAY function
    By Skoal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-22-2008, 09:39 PM
  5. Combining today +1 and weekday function
    By Monique in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-12-2005, 09:08 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