johnbird1988
Board Regular
- Joined
- Oct 6, 2009
- Messages
- 199
Hello,
I would like some help with a Employee absence tracker I have created.
I would like to started recording the number of occurring sick absence in a year. My file looks like below.
The "S"represents a sickness, and for John the number of occurring sick absences are 2 because the 10 and 11 day is a weekend. For Dave the occurring sick absence is 3.
Any help would be amazing.
Thank you,
John
[TABLE="class: grid, width: 10, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]05/01/2015[/TD]
[TD]06/01/20150[/TD]
[TD]07/01/2015[/TD]
[TD]08/01/2015[/TD]
[TD]09/01/2015[/TD]
[TD]10/01/2015[/TD]
[TD]11/01/2015[/TD]
[TD]12/01/2015[/TD]
[TD]13/01/2015[/TD]
[TD]14/01/2015[/TD]
[TD]15/01/2015[/TD]
[TD]16/01/2015[/TD]
[TD]17/01/2015[/TD]
[TD]18/01/2015[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dave[/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD]S[/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would like some help with a Employee absence tracker I have created.
I would like to started recording the number of occurring sick absence in a year. My file looks like below.
The "S"represents a sickness, and for John the number of occurring sick absences are 2 because the 10 and 11 day is a weekend. For Dave the occurring sick absence is 3.
Any help would be amazing.
Thank you,
John
[TABLE="class: grid, width: 10, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]05/01/2015[/TD]
[TD]06/01/20150[/TD]
[TD]07/01/2015[/TD]
[TD]08/01/2015[/TD]
[TD]09/01/2015[/TD]
[TD]10/01/2015[/TD]
[TD]11/01/2015[/TD]
[TD]12/01/2015[/TD]
[TD]13/01/2015[/TD]
[TD]14/01/2015[/TD]
[TD]15/01/2015[/TD]
[TD]16/01/2015[/TD]
[TD]17/01/2015[/TD]
[TD]18/01/2015[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dave[/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD]S[/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]