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
:

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

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

On Tuesday, January 29, 2013 10:18:12 AM UTC-5, Claus Busch wrote:
Hi,



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




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



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

That did the trick. Thank you Claus!

Amy