matching dates are not been matched

Discussion in 'Microsoft Certification' started by =?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=, Nov 22, 2006.

  1. column A in Sheet 1 has dates in the date format mm/dd/yyyy. column B in
    Sheet 1 is pulling dates from another sheet Sheet 2 and should be matching
    the corresponding dates and inputing a number from another column.

    The time it works is when I manually type the date in sheet 2 and by doing
    so break the link/reference of this cell to yet another file that is storing
    all the data to be sorted and then graphed.

    Is there a reason why the date in in the date column in sheet 2 is not able
    to be recongized by sheet 1.
    does date matching only workes when the date is a text or not a reference,
    and if so is there a way around it.

    thanks.

    dario
     
    =?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=, Nov 22, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Michael
    Replies:
    2
    Views:
    966
    Michael
    Nov 20, 2003
  2. Jens Haase

    Cisco Router not matching DSCP 46

    Jens Haase, Apr 27, 2006, in forum: Cisco
    Replies:
    7
    Views:
    12,925
    Jens Haase
    Apr 28, 2006
  3. Marc
    Replies:
    8
    Views:
    879
    Martik
    Jul 25, 2005
  4. lollipop
    Replies:
    2
    Views:
    611
    lollipop
    Aug 28, 2006
  5. dejola
    Replies:
    6
    Views:
    739
    jason43050
    Dec 30, 2005
Loading...

Share This Page