Antoniozarzal
New Member
- Joined
- Apr 25, 2016
- Messages
- 9
Hi MrExcel, I'm having a hard time trying to figure out how to do this.
I have a database where I register a date and a number of days lost per worker because an accident or an illness. For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date of accident/illness[/TD]
[TD]Number of days lost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28/05/2016[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
That information goes to an accumulate of days lost per month, no issues there. As you can see, those 6 days will appear all of them as if all 6 days were in May. Now I need that the 4 days of may appear in May's statistics (sum of days) and the 2 left to appear in June's statistics (also a sum of days).
Is there a way to do this?
Thank you a lot guys for any response and excuse me if I've made a mistake with the language.
I have a database where I register a date and a number of days lost per worker because an accident or an illness. For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date of accident/illness[/TD]
[TD]Number of days lost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28/05/2016[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
That information goes to an accumulate of days lost per month, no issues there. As you can see, those 6 days will appear all of them as if all 6 days were in May. Now I need that the 4 days of may appear in May's statistics (sum of days) and the 2 left to appear in June's statistics (also a sum of days).
Is there a way to do this?
Thank you a lot guys for any response and excuse me if I've made a mistake with the language.