Good morning everyone, I hope this is the place I can get some help with this....ill try to keep this problem short:
I have a spreadsheet for absence. Our corporate trigger levels where an employee progresses to a stage of absence are 6 days in a row,4 weeks in a row, 3 months in a row and or four separate absences within a rolling year. Now the sheet I have set up every time someone is absent I type the number 1 into the cell corresponding to the date and i have it counting the number of days absent in another cell. What i would like to do (if this is possible) is to have a pop up message appear when the count reaches 6 days and or 4 seperate occasions (this would need to somehow count any absences under six days as one absence until this reaches four?)
I know its all very confusing if you think your able to offer me some help i will try to simplify the explanation....one massive thanks in advance...
Tam
Scotland
I have a spreadsheet for absence. Our corporate trigger levels where an employee progresses to a stage of absence are 6 days in a row,4 weeks in a row, 3 months in a row and or four separate absences within a rolling year. Now the sheet I have set up every time someone is absent I type the number 1 into the cell corresponding to the date and i have it counting the number of days absent in another cell. What i would like to do (if this is possible) is to have a pop up message appear when the count reaches 6 days and or 4 seperate occasions (this would need to somehow count any absences under six days as one absence until this reaches four?)
I know its all very confusing if you think your able to offer me some help i will try to simplify the explanation....one massive thanks in advance...
Tam
Scotland