Need help with excel formulas!

Frequent Visitor

I am using the excel spreadsheet employee attendance.


I am also using Microsoft Office version Version : 18.2110.13110.0

I am trying to add one hour per month for PTO (personal time off) and cap out at 12 hours.

I know the formula I am using isn't right, but was trying to make it work. lol 
Plus add yearly vacation time, but I would like it to begin on the employees anniversary day.  I am no pro at excel, but was trying different formulas.

Employee Attendance Record 

Thanks for any and all help that I can get.

1 Reply


If you’re looking to ask a question or start a conversation about Excel, you’re in the right place.


Please include the following info to help others answer your question:

Welcome to your Excel discussion space!


Thank you for your understanding and patience



I know I don't know anything (Socrates)