So I was going through some old Excel files and came across a couple of calendars someone might find useful. When I was working, we were paid bi-weekly. In other words, every two weeks. There were three days I was concerned with:
- The end of the pay period (there was a five day delay between the end of the pay period and the day we were paid).
- The dates I was paid.
- The current day.
The first calendar is a yearly calendar. The whole year of payroll periods are set out on one Excel sheet, using conditional formatting. The only two pieces of information needed are any end of pay period date, and a pay day date. The calendar is perpetual after the two dates are entered. At the time of this post we are in 2019, however you will notice that I entered two dates in 2010 to start the calendar. On each first day of the year, the calendar will recalculate the new dates for that year. I some cases today’s date will be the same as a pay or period date, and today’s date overrides the other.
On the second sheet is a monthly calendar that uses the dates entered on the yearly calendar and shows the current month. Also, I have includes the holidays my firm observed and the holidays appear on the calendar. Like the yearly calendar, it is perpetual. The only changes you might make are to add or subtract holidays in the table. Note that each holiday is a formula, so that the holidays are perpetual also.