count sessions then restart 365 days after - help

**itsnotfair** · 06-29-2011, 08:47 AM

Hi Guys,

I have a spreadsheet like the example attached that counts the number of sessions that a person has (personal project I'm working on). I want to be able to count the number of sessions a person has had then input a 1,2,3 etc then after 365 days has passed from the first session restart the count - even saying it makes me lose it

. I don't know where to begin and if someone could help I would be extremely grateful.

Thanks

I'm a singing coach by the way and building this for myself - not a masseuse

**NBVC** · 06-29-2011, 09:09 AM

Assuming you have grouped the names together, and the dates are chronological for each group, then try:

=IF(A2<>A1,1,IF(LOOKUP(2,1/((A1:A$2=A2)*(C1:C$2=1)),B1:B$2)<=B2-365,1,C1+1))

**Marcol** · 06-29-2011, 09:31 AM

Another couple of possibilities.
In D2

Please Login or Register  to view this content.

Or as in Sheet2 use SUBTOTAL() then filter by Name and Year or any combination you might need.
In E1

Please Login or Register  to view this content.

Hope this helps

count sessions then restart 365 days after - help

LinkBack

Thread Tools

Rate This Thread

Display

count sessions then restart 365 days after - help

Re: count sessions then restart 365 days after - help

Re: count sessions then restart 365 days after - help

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions