Holiday and sick leave records
 

I would like to set up a spreadsheet to record staff leave. My point of
departure is a calendar in a spreadsheet for 2008 for each employee.
Should the person be sick, I enter an S. If he takes holiday leave, I
enter an H etc. etc. Below, or in another sheet/workbook, I will have
cells for this persons holiday, sickness etc. (together with others).

I am looking for a formula/formulas that says, if the value is H, then
increase the number in cell (in another sheet/workbook) with 1. This
formula will have to be repeated in each workday cell.

The reason for this is to have an exact number of holiday days left
available at all times.




--
impacter

Holiday and sick leave records
 

How about

="This person has taken " & COUNTIF(<range,"H") & " holidays off."


HTH,
JP

On Jan 4, 9:44*am, impacter
wrote:
I would like to set up a spreadsheet to record staff leave. *My point of
departure is a calendar in a spreadsheet for 2008 for each employee.
Should the person be sick, I enter an S. *If he takes holiday leave, I
enter an H etc. etc. *Below, or in another sheet/workbook, I will have
cells for this persons holiday, sickness etc. (together with others).

I am looking for a formula/formulas that says, if the value is H, then
increase the number in cell (in another sheet/workbook) with 1. *This
formula will have to be repeated in each workday cell.

The reason for this is to have an exact number of holiday days left
available at all times.

--
impacter