Hi
I have an array of boxes corresponding to each day of the month, into which I enter periods of sickness/absence by marking each day off with an "S". I can then count the number of days sick quite happily. I've been asked to count the number of occasions of sickness now, for example a person could have a days sickness on the 5th then 3 days later in the month. Under these circumstances I would need a count of two PERIODS of absence along with the 4 days absence.
Could someone please help point me to the correct function or a method of doing this? I'm a newbie so have no VBA skills... (any great sources for learning VBA btw?)
Many thanks
Dave
I have an array of boxes corresponding to each day of the month, into which I enter periods of sickness/absence by marking each day off with an "S". I can then count the number of days sick quite happily. I've been asked to count the number of occasions of sickness now, for example a person could have a days sickness on the 5th then 3 days later in the month. Under these circumstances I would need a count of two PERIODS of absence along with the 4 days absence.
Could someone please help point me to the correct function or a method of doing this? I'm a newbie so have no VBA skills... (any great sources for learning VBA btw?)
Many thanks
Dave
