I
impacter
I would like to set up a spreadsheet to record staff leave. My point o
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,
enter an H etc. etc. Below, or in another sheet/workbook, I will hav
cells for this persons holiday, sickness etc. (together with others).
I am looking for a formula/formulas that says, if the value is H, the
increase the number in cell (in another sheet/workbook) with 1. Thi
formula will have to be repeated in each workday cell.
The reason for this is to have an exact number of holiday days lef
available at all times
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,
enter an H etc. etc. Below, or in another sheet/workbook, I will hav
cells for this persons holiday, sickness etc. (together with others).
I am looking for a formula/formulas that says, if the value is H, the
increase the number in cell (in another sheet/workbook) with 1. Thi
formula will have to be repeated in each workday cell.
The reason for this is to have an exact number of holiday days lef
available at all times