hi,
i would like some help if possible. i want a worksheet that can count how many days someone has been off work sick for the past 12 months. this count has to update every day, so that it always displays the number of days sickness for the past 12 months from the current date. is this possible, and if so, how. the worksheet currently uses 2 cells for each date, one that displays the date and the one to the right that is for entering an "s" for sick or "l" for lieu day, or "h" for holiday etc. how can i check the cells to the right of each date for an "s" and count them for the past 12 months?
thanks stuart
i would like some help if possible. i want a worksheet that can count how many days someone has been off work sick for the past 12 months. this count has to update every day, so that it always displays the number of days sickness for the past 12 months from the current date. is this possible, and if so, how. the worksheet currently uses 2 cells for each date, one that displays the date and the one to the right that is for entering an "s" for sick or "l" for lieu day, or "h" for holiday etc. how can i check the cells to the right of each date for an "s" and count them for the past 12 months?
thanks stuart