I have a table called €œDates€� with data that looks like the following:



A B C A

3 Spin Start date End date Month of Spin

4 10 1/1/09 0:00 1/31/09 23:59 1

5 10 2/1/09 0:00 2/28/09 23:59 2

6 10 3/1/09 0:00 3/31/09 23:59 3

7 10 4/1/09 0:00 4/30/09 23:59 4

8 10 5/1/09 0:00 5/31/09 23:59 5

9 10 6/1/09 0:00 6/30/09 23:59 6

10 11 3/1/09 0:00 3/31/09 23:59 1

11 11 4/1/09 0:00 4/30/09 23:59 2

12 11 5/1/09 0:00 5/31/09 23:59 3

13 11 6/1/09 0:00 6/30/09 23:59 4

14 11 7/1/09 0:00 7/31/09 23:59 5

15 11 8/1/09 0:00 8/31/09 23:59 6

16 12 5/1/09 0:00 5/31/09 23:59 1

17 12 6/1/09 0:00 6/30/09 23:59 2

18 12 7/1/09 0:00 7/31/09 23:59 3

19 12 8/1/09 0:00 8/31/09 23:59 4

20 12 9/1/09 0:00 9/30/09 23:59 5

21 12 10/1/09 0:00 10/31/09 23:59 6


I have another sheet (Actuals) that provides a Spin number (Row A €“ €œSpin€�)
and a Date the report was generated (Row B €“ €œDate of report€�).



A B C

3 Spin Date of Report Month of Spin

4 10 1/15/2009

5 11 6/3/2009

6 10 5/5/2009

7 11 7/17/2009

8 11 4/25/2009

9 12 1/15/2009

10 12 9/15/2009

11 11 4/21/2009

12 12 5/23/2009

13 11 8/9/2009


How do I find the Month of the spin associated with the €œActuals€� data by
validating the Spin number and date match on the €œDates€� Spreadsheet??

Help!! Thanks much!!