View Single Post
  #1  
Old June 1st, 2010, 09:19 AM posted to microsoft.public.excel.misc
tonyagrey
external usenet poster
 
Posts: 10
Default Count of cells since first purchase

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 1
May 10
Account 1 2
3
Account 2 1
Account 3 1

Any help would be greatly accepted!

--
Tony