| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count#cells w/= value in other column and not count blank c | Excel Worksheet Functions | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| Purchase order | Excel Discussion (Misc queries) | |||
| how do i set up a purchase ledger | Excel Discussion (Misc queries) | |||
| purchase order counter in excel purchase order template | Excel Worksheet Functions | |||
Threaded Mode
