D
David Kenney
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/tutorial...9d-98f34bef0a9a/command-prompt-here-with.aspx
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/tutorial...9d-98f34bef0a9a/command-prompt-here-with.aspx