Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computer Certification > Microsoft Certification > matching dates are not been matched

Thread Tools

matching dates are not been matched

Posts: n/a
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.


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
RFC-822 dates into Ruby dates kellygreer1 Ruby 1 06-08-2008 10:59 PM
Need to use dates earlier than 1900 (Time library says out of range for dates < 1900) Ruby 1 07-17-2007 02:25 PM
FAQ Dates; Opera Dates. Dr J R Stockton Javascript 0 06-18-2007 03:51 PM
Dates dates dates dates... SQL and ASP.NET David Lozzi ASP .Net 1 09-30-2005 02:18 PM
Dates! Dates! Dates! PW ASP General 4 08-09-2004 04:42 PM