+ Reply to Thread
Results 1 to 2 of 2

Formatting =a1&" thru "&a5 when both a1 and a5 are dates

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    Formatting =a1&" thru "&a5 when both a1 and a5 are dates

    Want to end up with any format other than Microsoft's 5 digit date number.
    In this formula =a1&" thru "&a5, a1 reads 03-10-2013 and a5 which will always be 27 days after a1 reads 04-06-2013.
    But the output of =a1&" thru "&a5 is 41343 thru 41370 instead of the non microsoft date format the cell is formatted for.
    Question - How do i get what I want?
    Thanks
    Last edited by ILoveStMartin; 04-19-2013 at 07:59 PM. Reason: not done

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formatting =a1&" thru "&a5 when both a1 and a5 are dates

    You need to use the Text function on the dates

    Try
    =TEXT(a1,"mm/dd/yyyy")&" thru "&TEXT(a5,"mm/dd/yyyy")

    adjust the date formats mm/dd/yyyy to your liking.

+ 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