Sorry Tony, I realised on reflection that the formula I gave in my first
reply would only work if the purchase year and current year were the same. To
be able to count the weeks across any number of years try the following
instead:

Say you have column headers in A1 to C1: Account No., Date of 1st Purchase,
No. Weeks Since 1st Purchase

Then in A2 type 1, in B2 (which is formatted as a date) the date of Account
1's first purchase, then in C2 (which is formatted as a number to 1 d.p.)
this formula:

=DATEDIF(B2,TODAY(),"D")/7

The DATEDIF function will calculate the number of days between TODAY's date
and the date entered in B2, and the formula converts to weeks by dividing by
7.

Hope this is more in line with what you need.

Regards,

Tom


"tonyagrey" wrote:

Anyone?
--
Tony


"tonyagrey" wrote:

Hi,

Looking for a bit of help with the below.

I want to calculate how many weeks have passed since a customer first
purchased from me. So for example see below. I want to calculate in cell E2
how many weeks have passed since Account 1 first purchased from me. In cell
E3 i want to calculate how many weeks it is since Account 2 first purchased
from me.


Week 3 April Week 4 April Week 1May 10
Account 1 2 3
Account 2 1
Account 3 1

Any help would be greatly accepted!

--
Tony