Function Problems

Automatically Set an Excel Status to Funded When a Date Is Entered

Jason MillerJason Miller Nov 18, 2026 868 views

Question details

Automatically show Funded as an application status when a funding date is entered.

Automatically Set an Excel Status to Funded When a Date Is Entered
Product
Microsoft Excel
Device & OS
not provided
Scenario
An application tracker has a status drop-down and a separate funding date column.
Observed behavior
The status should change to Funded when a valid funding date is entered.
Before you start

Identify the funding date, decision, acknowledgment date, request date, and status columns in your worksheet. The examples below use row 5 and place the displayed status in column H; adjust the references to match your sheet.

Solution 1Recommended

Calculate the status with an Excel formula

Use a formula when the displayed status can be calculated from dates and a separately entered decision.

This example uses K for the funding date, G for the decision, E for the acknowledgment date, C for the request date, and H for the calculated status. Keep the decision input separate from the formula cell.

1
Prepare the status column

Use column H for the calculated status. If it has a drop-down intended for manual entry, select the relevant cells and use Data > Data Validation > Clear All to remove it.

2
Enter the formula

Select H5 and enter =IF(ISNUMBER(K5),"Funded",IF(G5<>"",G5,IF(ISNUMBER(E5),"Pending",IF(ISNUMBER(C5),"In Progress","??")))).

3
Fill and test the formula

Drag the fill handle from H5 down the status column. Enter a valid funding date in K5 and check that H5 displays Funded.

Calculate the status with an Excel formula
Enter dates as Excel dates: The formula checks for numeric date values. A date stored as text will not trigger Funded; convert it to a valid Excel date first.
Calculate application statuses

Calculate Funded Statuses in WPS Spreadsheets

Use a formula in WPS Spreadsheets to show Funded when a funding date is entered and calculate the other statuses from your tracker.

  1. 1. Open the tracker: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Choose the status cell: Select H5, or an empty status cell in your tracker. Keep the decision input in a separate cell.
  3. 3. Enter the formula: Enter =IF(ISNUMBER(K5),"Funded",IF(G5<>"",G5,IF(ISNUMBER(E5),"Pending",IF(ISNUMBER(C5),"In Progress","??")))) and adjust the column references if needed.
  4. 4. Fill and test: Drag the fill handle down the status column, then enter a valid date in K5 to confirm that H5 displays Funded.
  5. 5. Save the workbook: Select File > Save As and choose the XLSX format if you want to share the tracker with Excel users.
Automatically display Funded for rows with a valid funding dateOpen and save Microsoft Excel XLSX workbooksUse familiar spreadsheet formulas and fill handlesEdit application trackers with free spreadsheet tools
microsoft office alternative - wps office

Frequently Asked Questions

Can I use the formula and manually select a status in the same cell?

A manually entered value replaces the formula. Keep manual decisions in a separate column, such as G, and use H for the calculated status, or use the desktop Excel VBA option.

Why does the formula not show Funded after I enter a date?

Check that the formula refers to the correct funding date cell and that the date is stored as a numeric Excel date rather than text. Re-enter or convert the date if necessary.

What happens if I remove the funding date?

With the formula, the status recalculates using the decision, acknowledgment date, and request date. The sample macro does not restore the previous status when the date is cleared.

Can the macro update several rows when I paste funding dates?

Yes. The sample Worksheet_Change macro checks each changed cell within K5:K1000 and updates the corresponding cell in column H when it contains a valid date.