I have created a simple Excel spreadsheet in a Table format that I can use to track and help plan vacation time earned vs spent, which I have attached for reference.
I'm new to Excel and after a lot of Google searching to get as far as I am, I realize I need further help. What I would like to do is calculate from my Hire date how much vacation I have earned and what has rolled over after my hire date, but without going over the Maximum Cap, and continuing to deduct as I add more entries. I have future vacation plans highlighted so I can visually see and plan time off.
I want to make this as versatile as possible so I can use it in as many jobs as I get. Has someone done this before that can assist with my personal project?
I'm new to Excel and after a lot of Google searching to get as far as I am, I realize I need further help. What I would like to do is calculate from my Hire date how much vacation I have earned and what has rolled over after my hire date, but without going over the Maximum Cap, and continuing to deduct as I add more entries. I have future vacation plans highlighted so I can visually see and plan time off.
I want to make this as versatile as possible so I can use it in as many jobs as I get. Has someone done this before that can assist with my personal project?