Each year we publish a comprehensive leave record that federal employees can use to track their annual and sick leave, comp, and credit hours used. Our updated 2023 Excel Leave Chart is designed for active federal employees that are planning their retirement and need to establish realistic target retirement dates. This spreadsheet also helps federal employees maximize their annuity through prudent management of their leave balances.
I would like to thank two federal employees that beta tested this new version, Daniel and Shauna. Daniel provided significant formatting and content updates that added more functionality to the spreadsheet.
The 2023 leave year has 27 pay periods.
Please share our 2023 leave chart with everyone in your organization. It includes the Juneteenth national holiday. The chart tracks all leave balances, and you are able to annotate your work schedule on the chart as well. Simply download the spreadsheet to your desktop for easy access.
Download the 2023 Leave Chart
- 2023 Leave & Schedule Excel Chart (xls) 97-2003 version
- 2023 Leave & Schedule Excel Chart (xlsx) workbook version
If your spreadsheet opens in protected view click the “enable editing” button in the yellow bar at the top of the form. However, if you don’t see the enable editing button you may have an older version of Excel or your IT department may have to allow the form to pass without restrictions. We also included a newer slsx workbook version that you can use if you have problems with the earlier version.
A Microsoft Office consulting firm suggested using the newer slsx version. If that doesn’t correct the problem, talk with your IT staff. Some agencies increase their security settings to lock out certain documents based on set parameters. We include several hyperlinks in our spreadsheet to link users to additional supporting information such as our sick leave conversion chart and that may be the cause.
Helpful Retirement Planning Tools
- Retirement Planning for Federal Employees & Annuitant
- The Ultimate Retirement Planning Guide – Start Now
- Deciding When To Retire – A 7-Step Guide
- Medicare Guide
- Social Security Guide
- Budget Work Sheet
Last 5 posts by Dennis Damp
- Sick Leave Accrual: A Mid-Year Look at Your Retirement Math - September 12th, 2026
- FEHB Premiums Preview: What Early Signals Tell Us About 2027 - September 3rd, 2026
- Mid-Year TSP Contribution Check: Are You on Pace to Max Out? - August 29th, 2026
- The TSP 5-Year Rule for Roth Account Conversions - August 22nd, 2026
- How to Convert to a Roth IRA on a Small Budget - August 15th, 2026
Dennis V. Damp is an author, retired federal manager, business owner, career counselor and veteran. Damp is the author of 28 books, a recognized benefits expert, and a retired federal manager with 35 years’ service. Dennis has been a guest on hundreds of radio talk shows, CNN’s YOUR MONEY and the Lou Dobbs Cable TV shows, lectured at universities and colleges, produced Internet web sites and training videos, and has written hundreds of articles for national magazines and newspapers. His books have been featured in the Wall Street Journal, Washington Post, New York Times and U.S. News & World Report.
Dennis joined the Air Force in 1968 and spent over three years on active duty and an additional seven years with the Air National Guard. He was hired by the Department of Defense (DOD) after leaving active duty and transferred to the Federal Aviation Administration (FAA) in 1975. He spent the remainder of his career in various positions with the FAA. His last position was technical operations manager at the Pittsburgh International Airport’s air traffic control tower.
