I'm trying to analyse data relating to social care services. What I need to do is identify the number of hours of care provided in a financial year.
So for example, if Client 1 receives an hour of care per day x 7 days (we work on a Monday to Sunday week) and care starts on Wednesday 16th January 2008 and ends on Thursday 31st January 2008, I can manually work out that the client received 16 hours of care.
Another example would be Client 2 receives care Mondays for 3.5 hours, and Fridays for 1.5 hours and using the same start and end dates as the example above, again I can manually work out that the client received 10 hours as there would have been 2 Mondays x 3.5 hours and 2 Fridays x 1.5 hours between the start date of 16-01-2008 and end date of 31-01-2008.
I'm looking at around 2000 clients all with varying care needs and all with different start and end dates so what I would like to be able to do is count the number of occurences of each day between the start date and end date of care (i.e. how many Mondays, how many Tuesdays etc between date 1 and date 2) Is this possible?
Thanks
So for example, if Client 1 receives an hour of care per day x 7 days (we work on a Monday to Sunday week) and care starts on Wednesday 16th January 2008 and ends on Thursday 31st January 2008, I can manually work out that the client received 16 hours of care.
Another example would be Client 2 receives care Mondays for 3.5 hours, and Fridays for 1.5 hours and using the same start and end dates as the example above, again I can manually work out that the client received 10 hours as there would have been 2 Mondays x 3.5 hours and 2 Fridays x 1.5 hours between the start date of 16-01-2008 and end date of 31-01-2008.
I'm looking at around 2000 clients all with varying care needs and all with different start and end dates so what I would like to be able to do is count the number of occurences of each day between the start date and end date of care (i.e. how many Mondays, how many Tuesdays etc between date 1 and date 2) Is this possible?
Thanks