I have a table like this:

ID #	1	        2	        3	        4
From	11/1/2001	11/1/2002	11/1/2003	11/1/2004
to	10/31/2002	10/31/2003	10/31/2004	10/31/2005

And I have a separate cell with a date, say 12/15/2002.

I want to have a cell formula that takes the table and this separate
cell as an input, and outputs the ID #.  For the sample date, 2.  For
11/15/2004, the output would be 4.

Preferable to not have a VB function.

---

Clarification of Question by mykemyke-ga on 17 Jul 2005 10:33 PDT

shockandawe - that's exactly what I came up with over the weekend -
perfect though!  I'm going to cancel the question, but is there a way
to pay you the amount or should I not worry about it?

Lets say your categories are in range B1:F1
And your from dates are in B2:F2

lets say the date in question is cell A5 
then this formula in any cell will do the trick.

match(A5,B1:F1,B2:F2)

notice it doesn't use the from date at all. This works because there
aren't any gaps between the intervals starting on your "to" dates. It
just finds the cell that is the closest date match without going over
-- price is right style-- then reports the corresponding category.

it gets trickier if there are gaps in the intervals.

I goofed that function should read

=match(A5,B2:F2,B1:F1)