Employee Absence Schedule

**CPAC** · 05-26-2015, 12:23 PM

Hi I've tried to adapt the standard Employee Absence Schedule excel template and need a little help.

I've added a worksheet with total holiday days. I need the Holiday Days column to add up full(1) and half days(0.5) then subtract the figure form the days left (total holiday days worksheet). Sick days just need to add up sick days for the month. Unpaid absence just needs to add up unpaid absence days for the month. The holiday remaining column just needs to subtract the holiday days from the days left column.

I hope this all makes sense - Any help would be much appreciated.

Employee absence schedule-help.xlsx

**acroley1** · 05-26-2015, 01:30 PM

What will you put in a date to signify the difference between full and 1/2 day? F and H or 1 and .5? Or something else?

**acroley1** · 05-26-2015, 01:32 PM

Nevermind! I see it at the bottom of the February page now!

**acroley1** · 05-26-2015, 01:35 PM

Here's for the holidays: =COUNTIF(tblFebruary[@[1]:[ ]],"F")*1+COUNTIF(tblFebruary[@[1]:[ ]],"H")*0.5
Here's for the sick days: =COUNTIF(tblJanuary[@[1]:[31]],"S")
Here's for the unpaid absences: =COUNTIF(tblJanuary[@[1]:[31]],"U")

To total it up on the "Total Holidays Page" you'll need to do a SUMIF for each worksheet and add them together. Like this:
=SUMIF(January!A5:A12,'Total Holiday Days'!A2,January!AG5:AG12)+SUMIF(February!A5:A12,'Total Holiday Days'!A2,February!AG5:AG12)+)+SUMIF(March!A5:A12,'Total Holiday Days'!A2,March!AG5:AG12).... and continue through all your workbooks. I didn't look at every page...but it'll be imporant for the Holiday total to be in the same column on every tab (unless you're going to change reference in each part of the equation.

Thanks

**CPAC** · 05-27-2015, 02:29 PM

Brilliant. Thanks for the help! I've got a little further if you're interested, I think the formulas in the over view are something like....

http://www.excelforum.com/showthread...t=#post4084987

Thanks again for the help.

**SharonWilliams** · 06-04-2015, 06:20 AM

I need to be able to enter 0.5 days into my spreadsheet anywhere in the calendar. Can anyone please help.

**[email protected]** · 06-08-2015, 06:37 AM

@ Sharonwilliams
Please find below formula: add this is in the cell: AG5
=COUNTA(tblJanuary[[#This Row],[1]:[31]])-COUNTIF(tblJanuary[[#This Row],[1]:[31]],"H")/2

Employee Absence Schedule

LinkBack

Thread Tools

Rate This Thread

Display

Employee Absence Schedule

Re: Employee Absence Schedule

Re: Employee Absence Schedule

Re: Employee Absence Schedule

Re: Employee Absence Schedule

Re: Employee Absence Schedule

Re: Employee Absence Schedule

Thread Information

Users Browsing this Thread

Similar Threads

adding data to the employee absence schedule template

Excel 2010 employee absence schedule issue

[SOLVED] Employee Absence Schedule Template

Check this Employee was off or Absence

[SOLVED] Change the Employee Absence schedule template to 2006?

Bookmarks

Bookmarks

Posting Permissions