+ Reply to Thread
Results 1 to 3 of 3

combining dates together in one cell with a date format

  1. #1
    Registered User
    Join Date
    05-18-2009
    Location
    CA
    MS-Off Ver
    Excel 97,2003, & 2007
    Posts
    6

    combining dates together in one cell with a date format

    Hi guys,

    I'm trying to put together dates into one cell and when I do it gives the actual value (ie. 01/01/00 = 36526). So I have A1 = 01/01/00 and B1 = 06/01/00. I'm trying to put it together in cell C1 with this formula:

    =A1&","&" "&B1 result = 36526, 36678

    what I need is to make it a date format resulting in = 01/01/00, 06/01/00. I tried ofcourse to format it w/ date, also tried to put custom (mm/dd/yyyy). The data can go up to 20 or even more dates.

    I appreciate any help, thanks

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: combining dates together in one cell with a date format

    Use TEXT

    =TEXT(A1,"dd/mm/yy")&", "&TEXT(B1,"dd/mm/yy")

  3. #3
    Registered User
    Join Date
    05-18-2009
    Location
    CA
    MS-Off Ver
    Excel 97,2003, & 2007
    Posts
    6

    Re: combining dates together in one cell with a date format

    thanks!!! it worked!!!

    btw, great name "donkeyote"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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