Date match problem

  • Thread starter Thread starter testingwithfire
  • Start date Start date
T

testingwithfire

Hi all, new to group.

I'm struggling with a date match problem.

I have this row as A1 to A6. All cells except for the header are formatted as dates.

Create Date
1/28/2013
1/27/2013
1/26/2013
1/25/2013
1/24/2013
1/23/2013
1/22/2013
1/21/2013
1/20/2013
1/19/2013
1/18/2013
1/17/2013
1/16/2013
1/15/2013
1/14/2013

I have this value, formatted the same way, in a cell (say F3) off to the side:

1/25/2013

Doing MATCH(F3,A2:A16) returns 15. It should return 4.

I can provide the Excel sheet if need be.

Thanks for any pointers.
 
Hi,

Am Tue, 29 Jan 2013 07:09:12 -0800 (PST) schrieb
(e-mail address removed):
Doing MATCH(F3,A2:A16) returns 15. It should return 4.
Click to expand...

you didn't enter the third term of the formula.
Try:
=MATCH(F3,A2:A16,0)


Regards
Claus Busch
 
Hi,



Am Tue, 29 Jan 2013 07:09:12 -0800 (PST) schrieb




you didn't enter the third term of the formula.

Try:

=MATCH(F3,A2:A16,0)





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2
Click to expand...

That did the trick. Thank you Claus!

Amy
 
Back
Top