C
CrankyLemming
I have been asked to set up a table to record when staff need to be
interviewed about excessive sickness. Yay me.
Our rules are that, three periods of sickness (duration doesn't
matter) within the last _rolling_ six months, means a chat with the
manager.
What I thought to do was 5 columns:
Col A with name;
Col b with most recent sick date;
Col c, the previous sick period;
Col d with the sick period before that; and
Col e, the action to be taken.
I can't work out a formula to look at the dates and decide whether
they all fall within the 6 months of the 'current' date (ie, the most
recent sick date for each line, Col B)
Can anyone advise me on the best way forward, as I'm hopeless on VB
Thanks in advance
Steve
interviewed about excessive sickness. Yay me.
Our rules are that, three periods of sickness (duration doesn't
matter) within the last _rolling_ six months, means a chat with the
manager.
What I thought to do was 5 columns:
Col A with name;
Col b with most recent sick date;
Col c, the previous sick period;
Col d with the sick period before that; and
Col e, the action to be taken.
I can't work out a formula to look at the dates and decide whether
they all fall within the 6 months of the 'current' date (ie, the most
recent sick date for each line, Col B)
Can anyone advise me on the best way forward, as I'm hopeless on VB
Thanks in advance
Steve