G
Guest
I have a list of dates with values next to it. I want to always, based on the
date, look at the previous 4 numbers. Ex.
04/04/2007 1.00
04/05/2007 1.00
04/06/2007 1.00
04/10/2007 0.00
04/13/2007 1.00
04/16/2007 0.00
04/17/2007 0.00
So lets say the current date is 4/16/07, the sum would be 3, but if they
date were the the 17th the number would be 2, looking at the 16, 13, 10, 6. I
want to sum the last 4 numbers after a given date. Any help you can give,
THANKS
date, look at the previous 4 numbers. Ex.
04/04/2007 1.00
04/05/2007 1.00
04/06/2007 1.00
04/10/2007 0.00
04/13/2007 1.00
04/16/2007 0.00
04/17/2007 0.00
So lets say the current date is 4/16/07, the sum would be 3, but if they
date were the the 17th the number would be 2, looking at the 16, 13, 10, 6. I
want to sum the last 4 numbers after a given date. Any help you can give,
THANKS