Thread: NEED ASAP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vick Vick is offline
external usenet poster
 
Posts: 63
Default NEED ASAP

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