Build a Job Application Tracker in Excel

A job application tracker in Excel keeps your whole search in one table: where you applied, when, what happened and when to follow up. With TODAY, COUNTIF and conditional formatting, it also tells you how long you've been waiting and which applications need a nudge. This guide builds one step by step, and the skills it uses (counting, dates and formatting rules) are the same ones many Excel tests check.

How the job application tracker is laid out#

Use one row per application and one column per fact. Here is a small example:

The Days waiting values assume today is 1 November 2026; yours will be different. Useful extra columns are the job link, contact person, salary range and notes. Turn the list into an Excel table with Ctrl+T (Mac: ⌘T) so new rows pick up the formulas and formatting automatically.

Step 1: Add a Status drop-down#

A drop-down list keeps the status words identical, which COUNTIF needs. Select the Status cells, choose Data > Data Validation, set Allow to List and type this in Source:

Applied,Interview,Offer,Rejected,Withdrawn

Click OK. Now each Status cell offers the same five choices, and "interview " with a stray space can't sneak in.

Step 2: Set a follow-up date#

A follow-up date reminds you when to send a polite check-in email. A common habit is one week after applying. In E2:

=IF(D2="Applied",C2+7,"")

If the status is still Applied, the result is the applied date plus 7 days. Once the status changes, the cell goes blank, because you've heard back. Adding a number to a date works because Excel stores dates as day numbers. Format the column as a date. If a recruiter gives you a decision date, type that date over the formula for that row instead. A real date from the company is better than a rule of thumb, and it keeps your follow-up polite and well timed.

Step 3: Show days waiting with TODAY#

TODAY returns the current date and updates every time the file recalculates. Subtracting the applied date gives the days since you applied. In F2:

=IF(D2="Applied",TODAY()-C2,"")

Harbor & Co shows 47 on 1 November 2026. If Excel shows a date instead of a number, change the cell format to General or Number. The TODAY function guide explains how it recalculates, and the days between dates lesson practises DAYS, DATEDIF and TODAY.

To measure how long a company took to reply, add a Reply date column and use DAYS, which takes the end date first:

=DAYS(D2,C2)

In the exercise on this page, the reply date sits in D2 and the applied date in C2, so Northwind took 21 days (8 to 29 September).

Step 4: Count applications by status with COUNTIF#

COUNTIF counts the cells that match one condition. Build a small summary next to the table. With the statuses listed in H2:H6, type this in I2 and fill down:

=COUNTIF($D$2:$D$6,H2)

The example gives Applied 2, Interview 2, Rejected 1, Offer 0 and Withdrawn 0. Total applications are =COUNTA(A2:A6), which is 5.

A response rate shows how many applications got any answer:

=(COUNTA(A2:A6)-COUNTIF(D2:D6,"Applied"))/COUNTA(A2:A6)

That's 3 out of 5, or 60% when formatted as a percentage. The COUNTIF function guide lists the criteria you can use, such as "<>Rejected" to count everything still alive.

Step 5: Color stale applications#

Conditional formatting colors cells by a rule, so the colors change as your search moves. These two rules are the most useful.

Color each status: select the Status column, choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains, type Interview and pick green. Repeat with Offer (dark green) and Rejected (grey).

Flag applications waiting more than 14 days:

1. Select the rows, A2:F6.
2. Choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
3. Enter =AND($D2="Applied",TODAY()-$C2>14) and pick an orange fill.

The $ before D and C makes every cell in a row check the same two columns. Both Harbor & Co and Crestline turn orange. Practise conditional formatting to get comfortable with formula rules like this.

Step 6: Catch duplicate applications#

Applying to the same company twice for the same role can look careless. Select the Company column and choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. Any company that appears more than once is colored, so you can check before you apply again. The guide to highlighting duplicates in Excel shows how to check two columns together, such as company and role.

Two more habits keep the tracker useful:

• Sort by Applied (newest first) so this week's applications are at the top.
• Filter by Status to see only the ones still waiting before your weekly follow-up session.

Get more from the same skills#

This tracker uses the same pattern as many workplace sheets: a status column, dates and counts. The attendance tracker counts codes with COUNTIF, the order tracker adds lookups by ID, and the expiry date tracker uses TODAY to flag what's due soon.

Many employers test exactly these skills. When you get an interview, try the Excel screening quiz to check you're ready for a short online test.

Practise it#

Do the exercise on this page: count the days between applying and hearing back with DAYS. Then practise COUNTIF in a live spreadsheet for your status summary, practise days between dates with DAYS and TODAY, and practise conditional formatting so stale applications color themselves.