Hi all,

Hope you can help - I have limited excel knowledge and I'm stumped with a request from my boss:

I have a stsff sickness/leave monitor spreadsheet.

It has a summary worksheet, and 12 monthly sheets.
On each monthly sheet I have staff names listed in column B (B4 to B40), with dates in row 3 (Example January runs from C3 to AF3). In each row I currently enter a 1 for a full day holiday, 0.5 for half a day holiday and "S" for a days sickness. Sums for holidays and sickness are shown in the summary sheet.

I need to show my boss occurences of sickness for each member of staff (so if someone has a day off during the week, then another the following week - that ciounts as two. If someone has a friday off, then a monday - that counts as one).

I hope this makes sense!


Submitted via EggHeadCafe - Software Developer Portal of Choice
Command Prompt Here with VS.NET Environment
http://www.eggheadcafe.com/tutorials...here-with.aspx