This is pretty simple. You need to add another row (or column) to your date
table to indicate that the chair has been checked (the X data below). You
also need to add to the date list everytime a set is occupied. the n all you
have to do is count the number of time the chair appears in the date list
without an X. Then add the X to the date list indicating that it has been
checked.

date 03.01.07 03.02.07 03.03.07........
X X X

I am trying to create a macro to tell me how many times a seat has been
occupied since it was last checked.

i.e. seat 1 checked on 3.13.07

column A column b
seat number check date
1 3.13.07

I have a separate data report which identifies on a per day basis how many
times the chair was used. i.e.

date 03.01.07 03.02.07 03.03.07........
chair number
1
2
3
......

I need to qualify how many times (not the last time) the chair was used
since the last date it was checked.

ANY SUGGESTIONS?
I am really lost here.....