+ Reply to Thread
Results 1 to 3 of 3

Referencing date in another cell in text

  1. #1
    Forum Contributor wmorrison49's Avatar
    Join Date
    09-25-2007
    Posts
    267

    Referencing date in another cell in text

    Here's what I am trying to do:

    In cell A1, I have a date "6/1/2008"
    In A3, I want it to say "The date A1 is in the middle".

    In A3, I put:

    ="The date " & A1 & " is in the middle."
    but this returns the number that Excel uses to calculate the dates, which in this case is an integer over 30,000. So everything comes out fine except for the date. Is there a way to keep the date formatted as a date when calling it this way?

    Thanks,
    Will

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Try this formula instead:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor wmorrison49's Avatar
    Join Date
    09-25-2007
    Posts
    267
    That worked, thanks a lot pjoaquin!

+ 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