Employee Absence Schedule

Hello,
I have basic skills with Excel...I am using the Employee Absence Schedule template. I need to modify the formulas so that the following is adjusted:
Add a "days picked up" category that will add days to the total in column AH. Also, I would like the "sick days" not to effect the numbers in the total AH column but to be totaled in an additional column. Any help appreciated!
Thank you,
Amara

Hi scottiex,
Thank you for your reply! This is a dumb question...my first time on this type of forum... How can I attach the draft I have in a reply so you can see a clearer description of what I am looking for. I have added columns that describe clearly and exactly how I would like it to look, just don't know the formulas. The formula you gave me is perfect and does what I am looking for for one of the columns, so thank you for that! Any further help appreciated

If you want to attach a sample Excel workbook, here's how to do it:

Click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do NOT try to use the Paperclip icon, as this does not work on this forum.

Hope this helps.

Pete

Hey, thanks Pete! If anyone can take a look at what I am working on and help me get the formulas that would be great. I have put a description of what I need in the columns on the right... Thank you!

This is it!!! Thank you! And now I understand what the formulas are and why and how to re-create. Greatly appreciate your help! Next question: is there a way to make the rest of the months/sheets be constructed the same without manually recreating each column/cell?