View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Smith Jim Smith is offline
external usenet poster
 
Posts: 5
Default Determining volume/number.

Thanks very much! That gets me on the right path. I appreciate your
help.


On Fri, 17 Feb 2006 15:58:27 -0800, Gary''s Student
wrote:

I am sorry Jim, I am still off by one year:

Sunday Paper

In A1 put 9/13/1981
in B1 put 1
in C1 put 1

In A2 thru C2 put:
=A1+7 =DATEDIF($A$1,A2,"y")+1 =IF(B1=B2,C1+1,1)
Then copy A2 thru C2 down to row#2500

The table appears to track to your requirements. The volume bumps on the
aniversery date and the number re-sets to one when the volume bumps.

But if you look at row#1276 you will see 2/19/2006 25 23

My volume is still off by one.


Perhaps 9/13/1981 should be Volume 2 number 1???