I'm operating Microsoft Excel for Mac, version 16.77.1, Office Home & Student 2021
I'm looking for an interactive annual calendar to predict and track my pay.
I work a rotating day and night shift schedule with different pay component. Base pay, Shift differential, Shift turn over, overtime, 3 different holiday pay types. each days pay can consist of one or more of these components. these pay rates change annually on February 1.
I'm open to the format but i envision a calendar with the months placed vertically and each months dates placed horizontal below each month. Below the dates for each month a horizontal line that auto fills with my schedule with the ability to add and edit to calculate the projected pay for each period. A column to the right of the calendar showing all 26 pay periods and the pay for each.
I am open to suggestions for the layout and structure of the sheet.