Hello All:
It's been a while since I've posted but I think I've got a good one for you guys. Long and short, I want to be able to change pay scales mid-month/year. The best way that I can think of is to have a cell designated for each pay period to set the pay scale and use a bunch of if statements to do what I'm needing.
Where the problem comes in is trying to configure the dates to match each pay scale. On the first page of the workbook, you'll see the pay scales I'm wanting to setup. The first 3 are the main focus but I believe the others can be done just as easily. Scale #5 is in there for the chance that an employer randomly selects set days in the month that an employee is paid.
If you look at the January sheet, you'll see the problem I'm having. So far, I've been trying to use If statements. (Which may end up being the best way to do it.) The reason that I need to have the schedule for each day of the week is because of the possibility of overtime.
I've been running my budget this way for years but I want to set a template that will configure this much for me each year so that I don't have to go in each year and manually build all of it. It's getting to be a pain. I'm wanting to establish a template that I can use each year and then provision everything else that I've already got built and automated as much as possible. (Not shown in the attachment.) For now the January sheet is the test sheet. Once it's figured out, then I'll duplicate it on the other sheet/months.
Any help would be greatly appreciated. Feel free to pm me.
Thank You,
AJ