+ Reply to Thread
Results 1 to 3 of 3

Combined date not formatting correctly

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    2013
    Posts
    343

    Combined date not formatting correctly

    I have two dates that are created with the today formula. I want to combine those dates into one cell to show a date range. The problem is when I combine the two cells the formatting gets messed up and only shows the numeric representation of the date. how can I get it to show the date as 1/03/2022 instead of 44564?
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    6,440

    Re: Combined date not formatting correctly

    Please try
    =TEXT(A1,"m/dd/yyyy ")&TEXT(B1,"m/dd/yyyy")

  3. #3
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    2013
    Posts
    343

    Re: Combined date not formatting correctly

    Quote Originally Posted by Bo_Ry View Post
    Please try
    =TEXT(A1,"m/dd/yyyy ")&TEXT(B1,"m/dd/yyyy")
    That's the ticket! Thanks.

+ 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. Conditional Formatting on date - not working correctly
    By LeanneHMUA in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-25-2020, 07:48 AM
  2. Date not formatting correctly
    By jambog in forum Excel General
    Replies: 12
    Last Post: 03-06-2017, 03:01 PM
  3. Cell linked to Microsoft MonthView Control not formatting date correctly.
    By jeffadvanced in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2016, 05:08 PM
  4. [SOLVED] Date not formatting correctly
    By Plasma in forum Excel General
    Replies: 9
    Last Post: 05-06-2016, 02:30 PM
  5. [SOLVED] Correctly formatting a date inserted from an input box
    By dekueb in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-25-2016, 02:16 AM
  6. X axis Dates not appearing correctly in combined chart
    By ballstopicasso in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-02-2014, 06:49 AM
  7. Date Not Formatting Correctly
    By sam8114 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2013, 02:09 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