Announcement

Collapse
No announcement yet.

[Solved] VLOOKUP Date format

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Solved] VLOOKUP Date format



    Does anyone know why I cannot get my VLOOKUP and CONCATENATE to display the dates?

    =DATEVALUE(CONCATENATE(VLOOKUP(L22,Billing,8,FALSE)))

    I keep getting a #VALUE!

    The function looks up two date fields. I want it to display as per example:
    24-Mar-03 : 5-May-03

    thanks
    happy colin

  • #2
    DATEVALUE converts a date in the form of text to a number in XL date - time code

    CONCATENATE concatenates text strings

    Your VLOOKUP may return text string 1, but where is the other value you want to concatenate??

    Say C16 and D16 contain two dates
    placing this in D17
    =TEXT(C16,"dd-mmm-yy")&":"&TEXT(D16,"dd-mmm-yy")

    will return a value of
    01-Jan-03:02-Jan-03

    Hope this helps
    Kind Regards, Will Riley

    LinkedIn: Will Riley

    Comment


    • #3


      Thanks WillR

      that fixed the problem. you saved me hours of frustration.
      happy colin

      Comment

      Working...
      X