Hi,
I need to find out the number of days a membership is active (from start to end) for each customer. The problem is that the start and end date is not consistent. Please see the attachment. Pls let me know if I need to explain it better.
Thank you Hui.
This works when the start and end is at the beginning and end of the year. This also works at the startup of a member. But as in this case there should be 365 days in 2010: From 01.01.2010 to 15.08.2010 (from previous membership enrollment period) and then from 16.08.2010 to 31.12.2010.
2009 16-aug-2009 15-aug-2010
2010 16-aug-2010
15-aug-2011
Hello, thanks for the trying to help me
I have changed the file a little and added more members/customers. I need to find the correct number of days in column G.
Thanks!
I'm not sure that I have correctly interpreted your question, but the attached will give the number of days between "Start" and "End" during the calendar year given in "UW year."
Hi, let me try to explain it differently that is hopefully not so difficult:
A customer membership starts and ends on some arbitrary days. It can end in a different year than it starts. A new membership period begins the day after the previous one ended.
I have a list of the Start and End dates of these membership periods. I need to determine the number of calendar days during each calendar year that the membership for that customer is in effect.