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???
|