Automatically Set an Excel Status to Funded When a Date Is Entered
Question details
Automatically show Funded as an application status when a funding 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.
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.
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.
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.
Select H5 and enter =IF(ISNUMBER(K5),"Funded",IF(G5<>"",G5,IF(ISNUMBER(E5),"Pending",IF(ISNUMBER(C5),"In Progress","??")))).
Drag the fill handle from H5 down the status column. Enter a valid funding date in K5 and check that H5 displays Funded.

Update a manual status drop-down with a worksheet macro
Use a VBA worksheet event in desktop Excel if users need to keep manually selecting a status in the same cell.
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. Open the tracker: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Choose the status cell: Select H5, or an empty status cell in your tracker. Keep the decision input in a separate cell.
- 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. 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. Save the workbook: Select File > Save As and choose the XLSX format if you want to share the tracker with Excel users.

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.




