Need A Help

[chamira]

Hi,
First I must admit that i'm not so good at Ms.Excel (specially with macros). So i dunno whether my problem is a piece of cake or it's totally impossible. So pls have a look and help me.

Currently I'm making a attendance sheet. I must have following abilities in that sheet.
Situation

• If someone works for 2 days he gets a day off.
• He can accumulate his day offs and take them altogether at once (for instance one can work 10 days continuously and accumulate 5 day offs and take them continuously)
• Or he can take his accumulated day offs as he wishes.
• BUT, he can only have 8 accumulated day offs max (means he only can work for 16 days continuously and get 8 day offs at once. If he works more than 16 days (say 18) he gets 9 accumulated offs but 1 off out of the 9 offs gets forfeited (if he has 10 accumulated, 2 to be forfeited ,like wise)
• So despite having a number of accumulated day offs he is eligible to take only a maximum number of 8 day off.

Need

• A workbook with employees names showing their Worked Days, Accumulated Offs, Total Forfeited Offs, Eligible Offs, for a period of time.

Thank you.
P.S. I'm using MS. Excel for mac 2011

 

[Michael M]

If you Google

excel attendance template for mac

you should get plenty of available options you can modify to suit your needs !

 

[chamira]

If you Google

excel attendance template for mac

you should get plenty of available options you can modify to suit your needs !

Thank u for ur advice i'll try that one too
But still prefer an excel workbook