Month-End Close Gantt Chart
A daily Gantt chart for a finance team's month-end close. Activities, owners, dependencies, start day and duration drive a weekday-only timeline, public holidays are flagged automatically and a pop-up calendar fills dates with a double-click.
- Industry
- Corporate Finance and Accounting
- Deliverable
- Daily Gantt Chart.xlsb
- Built with
- Excel VBA, UserForms, Conditional formatting
Before
The close schedule was a static task list, so delays and clashes with holidays were easy to miss.
After
Each activity's start day and duration draw it on a weekday timeline, with holidays flagged in red.
Related projects
Baseball Roster & Lineup Generator
Sports
Creates fair fielding lineups for a youth baseball team. Positions are randomised inning by inning while the equalizer rules make sure every player sits, catches and…
Launch Readiness Tracker
Pharmaceutical Launch
A product launch readiness tracker with grouped task buckets. Add and delete task buttons keep the structure intact, a double-click calendar fills dates, and the Gantt…
Project Planner & Gantt Chart
Pharmaceutical Launch
A launch plan with more than a hundred tasks. Tasks, owners, priorities and dates are entered in the planner and the Gantt chart, progress counters and…