90 Day Plan Template Excel: Columns, Formulas and a Filled Example
8 min read ยท 2026-11-16
A working 90 day plan template excel file needs one action per row, ten columns from Phase to Late, three drop-down lists and three formulas: current week, percent done and a late flag. Paste the header row below, add the formulas, and the sheet shows your progress and anything behind schedule each Friday without extra work.
This guide covers the spreadsheet only. You get the header row to copy, the exact list values, formulas you can paste, color rules by week and a filled example for a new IT manager.
The roadmap at a glance
Goal: Build a 90 day plan sheet that tracks itself, then use it every week through days 30, 60 and 90. Duration: 13 weeks, plus one week of setup
Build the file (Week 0, before day 1)
Set up the sheet once, so the first weeks go to people and not to formatting.
- Paste the header row and add the three drop-down lists.
- Enter your start date and paste the progress and late formulas.
- Add the four color rules.
- Write a first draft of three goals per phase and book the reviews for weeks 4, 8 and 13.
Milestone: The file calculates the current week and percent done, and your manager has the draft.
Learn (Days 1-30)
Fill the Learn rows and update the status every Friday.
- Mark each row Done, In progress or Blocked by the end of every week.
- Check the late count before your week 4 review.
- Rewrite the Contribute rows using what you learned.
Milestone: Day 30 review held, Learn rows at or near 100 percent, Contribute rows approved.
Contribute (Days 31-60)
Track one or two visible improvements.
- Filter on Contribute and In progress to prepare each weekly check-in.
- Move any Blocked row to a new week or a new owner, and log the reason in Notes.
Milestone: Day 60 review held and first improvement live.
Take ownership (Days 61-90)
Use the sheet to hand over a clean plan for the next quarter.
- Close or drop every open row and give a reason for each drop.
- Copy the sheet and reset it for days 91 to 180.
Milestone: Day 90 review held and the next quarter sheet is ready.
The header row to paste
Type or paste this line into cell A1: Phase,Goal,Action,Owner,Due week,Measure,Target,Status,Notes,Late
Then select A1 and go to Data, Text to Columns, choose Delimited, tick Comma only and click Finish. The line splits into ten columns, A to J. Each column holds the following.
Freeze row 1 with View, Freeze Panes, Freeze Top Row. Turn on Data, Filter so you can show one phase or only the late rows during a meeting.
- Phase (A): the 30 day block the row belongs to.
- Goal (B): what should be true at the end of the phase, written as a result.
- Action (C): one concrete task. If a row needs the word "and", split it into two rows.
- Owner (D): you, your manager or a named colleague.
- Due week (E): a plain number from 0 to 13. Do not write "Week 3". The formulas need a number.
- Measure (F): the fact that proves the row is done.
- Target (G): the value you aim for, or "yes".
- Status (H): from a drop-down list.
- Notes (I): blockers, decisions and who agreed.
- Late (J): filled by a formula. Never type in it.
Drop-down list values
Use Data, Data Validation, then Allow: List, and type the values separated by commas.
Fixed values matter because every formula below looks for the exact words "Done", "Learn" and so on. One "done " with a trailing space breaks the count.
- Phase, cells A2:A100: Learn,Contribute,Take ownership
- Status, cells H2:H100: Not started,In progress,Done,Blocked
- Due week, cells E2:E100: choose Allow: Whole number, between 0 and 13. Week 0 is the setup week.
Formulas to paste
Keep the settings in columns L and M, to the right of the plan, so everything sits on one sheet. Put each label in column L and its formula in column M.
M2 shows 1 during your first seven days and 13 in the last week. It shows 0 before you start. Format M3 to M6 as percentages. M3 divides the Done rows by the rows that have an action, so empty rows do not lower the score.
A row is late when it has an action, is not Done and its due week has passed. These five numbers are what your manager reads first at each review: current week, percent done per phase and late actions.
- Start date (L1, M1): your first day, typed as a date.
- Current week (L2, M2): =MAX(0,INT((TODAY()-$M$1)/7)+1)
- Done overall (L3, M3): =IFERROR(COUNTIF($H$2:$H$100,"Done")/COUNTA($C$2:$C$100),0)
- Learn done (L4, M4): =IFERROR(COUNTIFS($A$2:$A$100,"Learn",$H$2:$H$100,"Done")/COUNTIF($A$2:$A$100,"Learn"),0)
- Contribute done and Take ownership done (L5, M5 and L6, M6): the same formula with "Contribute" and "Take ownership".
- Late flag (J2, filled down to J100): =IF(AND($C2<>"",$H2<>"Done",$E2<>"",$E2<$M$2),"Late","")
- Late actions (L7, M7): =COUNTIF($J$2:$J$100,"Late")
Color rules by week
Select A2:J100, then go to Home, Conditional Formatting, New Rule, "Use a formula to determine which cells to format". Add these four rules.
Keep Done at the top of the list in Manage Rules. With that order, opening the file on Friday shows grey for finished work, yellow for this week and red for what slipped.
- Done: =$H2="Done", light grey fill. Tick Stop If True in the rules manager so a finished row stays grey.
- Late: =$J2="Late", light red fill.
- This week: =AND($E2=$M$2,$H2<>"Done"), light yellow fill.
- Blocked: =$H2="Blocked", orange text.
Filled example: a new IT manager
A new IT manager joining a team of six. Each row below uses the column names of the sheet.
In week 4, the system list row turns red if it is still In progress, and the late count shows 1. That is the question to raise at the day 30 review. Every measure is something your manager can check without asking you.
- Learn: Action: one to one with each of the 6 team members. Owner: me. Due week: 2. Measure: one to ones held. Target: 6. Status: Done.
- Learn: Action: list every system with its owner and contract end date. Owner: me and the service desk lead. Due week: 3. Measure: list shared with my manager. Target: yes. Status: In progress.
- Learn: Action: group the last 90 days of tickets by cause. Owner: me. Due week: 4. Measure: top causes written down. Target: 5. Status: Not started.
- Contribute: Action: start a weekly 30 minute team meeting with notes. Owner: me. Due week: 5. Measure: meetings held in a row. Target: 4. Status: Not started.
- Contribute: Action: fix the top ticket cause from the week 4 list. Owner: service desk lead. Due week: 7. Measure: tickets for that cause. Target: lower than the week 4 count. Status: Not started.
- Take ownership: Action: present the next year IT budget draft to finance. Owner: me and my manager. Due week: 11. Measure: draft presented. Target: yes. Status: Not started.
- Take ownership: Action: agree 3 monthly measures with my manager. Owner: me. Due week: 12. Measure: measures agreed. Target: yes. Status: Not started.
Excel, Word or a visual roadmap: which one to use
Each format has one job, and most people need two of them.
A simple rule: track in the sheet, agree in the document, present with the visual. When you present, show the phases, the milestones and the percent done per phase from M4 to M6. Keep the action rows ready for questions.
- Excel: best for weekly tracking, filters, formulas and status. It is weak for presenting, because fifteen rows do not tell the story of the 90 days.
- Word: best for approval and a written record. It is weak for tracking, because statuses go out of date.
- A visual roadmap: shows the three phases, the milestones and the review dates on one screen. It is best for presenting to a director, a team or a client.
Common mistakes to avoid
- Typing "Week 3" in Due week breaks the sheet, so use the number 3, or the late flag and color rules stop working.
- Writing statuses by hand lets typos in, so use the drop-down, or COUNTIF misses rows.
- Adding forty rows buries the plan, so keep three to five goals per phase and about fifteen action rows in total.
- Updating the sheet only before reviews hides slippage, so spend five minutes every Friday to keep the late count honest.
- Deleting dropped rows erases the history, so mark them Done and write "dropped" and the reason in Notes.
- Letting the new hire own every row hides who must act, so add your manager and colleagues as owners where they must act.
Frequently asked questions
Is there a free 90 day plan template in Excel?
Yes. Paste the header row above into A1, split it with Text to Columns, add the three drop-down lists and the formulas. You get a free, working template for any role in under an hour.
How do I calculate percent complete in a 90 day plan?
Use =COUNTIF(H2:H100,"Done")/COUNTA(C2:C100) and format the cell as a percentage. For one phase, use COUNTIFS with the phase name and "Done", divided by COUNTIF on the phase name.
How do I highlight overdue tasks by week in Excel?
Store the due week as a number, calculate the current week from your start date with =INT((TODAY()-start)/7)+1, then add a conditional formatting rule that turns a row red when the due week is lower than the current week and the status is not Done.
Does this template work in Google Sheets?
Yes. COUNTIF, COUNTIFS, TODAY, INT, IF and IFERROR work the same way. Drop-down lists are under Data, Data validation, and the color rules under Format, Conditional formatting, with "Custom formula is".