I have information that looks like this.

Name1 Name2 Name3
Wed 11/01 N 0 1
Thu 11/02 N 1 0


It has the name going across and the date down the side. You can ignore the
N that is a seperate column that is used. What I need to do is for a given
date lets say 5/1, I need to count back 45 0's or 1's, and sum that amount.
The problem is not everyone has a count for that day. Any suggestions or how
I can find out what date I have to go back to find a count of 45 so I can sum
off of that date?

Thanks
Vick