(re-posted)

Hello People,

I have been asked to develop a spreadsheet into which absence data can be entered, and flagged up if the data meets following 3 criteria;

more than 3 occasions of absence in any rolling 3 month period
More than 2 weeks continuous absence
More than 6 weeks cumulative absence in any rolling 12 month period

For each month, there is a sheet, for example, "Month 1", and within each sheet there is a table containing employee specific info starting from column AI (name, DOB, sick pay entitlement etc), a column for each day of the month for entering an absence code, i.e. "S" for Sick etc, and a last column for flagging up the when one of the criteria has been met. Before Column AI is the previous months data

There is also a sheet summarizing the total sick days for the year by month, with the previous years data hidden away again before the emplyee info

So far i have managed to flag up the above using various IF type formula, but was asked if i could include a "dealt with" cell so all data prior to the "dealt with" date is ignored?!

we are using excel 2003 so cant have a cell for each day of the year, hence the separate sheets per month.

Im OK with formulas, but at using VBA im a novice.

Can anyone give me some advice as to how to achieve this flagging up / dealt with process?

Any help would be much appreciated.

Thanks in advance!