+ Reply to Thread
Results 1 to 4 of 4

One cell with text added to a fomula but formatting is incorrect

  1. #1
    Registered User
    Join Date
    10-24-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    2

    One cell with text added to a fomula but formatting is incorrect

    Think I can explain this without adding a file. Current version is Office 365

    Cell A1 is todays date, Cell A2 is 14 days after today. File set such that whenever it is opened, regardless of the date, A2 is always 14 days later than the date you opened it. Example

    A1 =TODAY()
    A2 =A1+14

    A1 10/24/23
    A2 11/7/23

    Now, I want to add text to A2 to say something like "Due by". So I modified the cell A2 to ="Due by " &A1+14. What I get as a result is this:
    A1 10/24/23
    A2 Due by 45237

    I can not figure out how to get the cell to show the correct date in A2. Any thoughts?

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: One cell with text added to a fomula but formatting is incorrect

    Give this a try...

    ="Due by " & TEXT(A1+14,"mm/dd/yy")
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    10-24-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    2

    Re: One cell with text added to a fomula but formatting is incorrect

    that did it! Many Thanks!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: One cell with text added to a fomula but formatting is incorrect

    That is great to hear. You are very welcome and thanks for the feedback!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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] Worksheet Shows Incorrect Calculation When % Percentage Is Added
    By klownzold in forum Excel General
    Replies: 12
    Last Post: 10-08-2021, 08:24 AM
  2. Need help with Conditional Formatting or Fomula
    By BZ-Boy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2017, 02:49 PM
  3. [SOLVED] Insert Cell made up of another specific cell with additional text added at the end
    By MICowboy13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2014, 01:30 PM
  4. [SOLVED] VBA Formatting Added T Incorrect Column
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2014, 09:50 AM
  5. Execute Now fomula based on text in another cell
    By Joker757 in forum Excel General
    Replies: 2
    Last Post: 05-02-2012, 08:20 AM
  6. Replies: 1
    Last Post: 06-15-2009, 11:28 PM
  7. Replies: 3
    Last Post: 02-06-2008, 06:40 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