Calculation Issues

Find the Date When Cumulative Growth Reaches a Target in WPS Office Spreadsheets

Khadija KhanKhadija Khan Nov 13, 2026 869 views

Question details

The user needs to find the first date when cumulative daily growth equals or exceeds a selected target after a chosen start date in WPS Office Spreadsheets.

Find the Date When Cumulative Growth Reaches a Target in WPS Office Spreadsheets
Product
WPS Office Spreadsheets (Excel-compatible)
Device & OS
not provided
Scenario
The user has a data table with dates and daily growth values, selects a starting date, and needs to identify the exact date when the cumulative growth reaches a required amount.
Observed behavior
The user wants to use a formula or helper column to return the first qualifying date instead of scanning the running total manually.
Before you start

Make sure your data is arranged in ascending date order with a Date column and a numeric daily growth column. Enter the selected start date and the required growth target in separate input cells so the formulas can reference them.

Solution 1Recommended

Use a Helper Running Total Column and XLOOKUP to Return the Date

Best for current WPS Office versions that support XLOOKUP. It keeps the calculation simple and easy to audit.

A helper column stores the running total from the selected start date. XLOOKUP then finds the first total that is equal to or greater than the target.

1
Enter the start date and target

Type the starting date in cell F1 and the required growth target in cell F2.

2
Add the running total helper column

In cell C2, enter =IF($A2<$F$1,0,SUMIFS($B$2:B2,$A$2:A2,">="&$F$1)) and fill down through all data rows. This keeps a zero total before the selected date and accumulates daily growth from that date onward.

3
Return the first matching date with XLOOKUP

In cell F3, enter =XLOOKUP($F$2,$C$2:$C$100,$A$2:$A$100,"Not reached",1). This returns the first date whose running total is equal to or greater than the target.

Use a Helper Running Total Column and XLOOKUP to Return the Date
Result ready: Cell F3 now shows the first date when cumulative growth reaches the target.
WPS Office How-To

Find the First Date Your Cumulative Growth Hits the Target in WPS Office Spreadsheets

Use WPS Office Spreadsheets to add a running-total helper column and apply XLOOKUP or INDEX/MATCH to return the first date when the selected cumulative growth meets your required amount.

  1. 1. Open your workbook in WPS Office: Launch WPS Office Spreadsheets and open the Excel workbook that contains your date and daily growth data.
  2. 2. Set up input cells: Enter the start date in cell F1 and the required growth target in cell F2.
  3. 3. Create the running total helper column: In cell C2, enter =IF($A2<$F$1,0,SUMIFS($B$2:B2,$A$2:A2,">="&$F$1)) and fill down through every data row.
  4. 4. Use XLOOKUP to return the first matching date: In cell F3, enter =XLOOKUP($F$2,$C$2:$C$100,$A$2:$A$100,"Not reached",1) and press Enter.
Automatically returns the first date that meets your cumulative growth target.Uses familiar WPS Office Spreadsheets formulas and a helper column, avoiding manual checking.Opens .xlsx, .xls, and other Microsoft Excel formats without conversion.Free and lightweight Office suite with a familiar ribbon interface.
microsoft office alternative - wps office

Frequently Asked Questions

Can I find the date if the required growth is between two daily totals?

Yes. Use XLOOKUP with match mode 1, or use INDEX/MATCH with a TRUE >= condition, to return the first date where the running total is equal to or greater than the target.

Does WPS Office support the Microsoft 365 LET/SCAN/LAMBDA formula shown in some Excel examples?

Some current WPS Office versions support dynamic array formulas, but support varies. The helper-column method in this article works broadly across WPS Office and Excel versions without requiring LAMBDA or SCAN.

What if my cumulative growth never reaches the target?

The XLOOKUP formula returns "Not reached". If you use INDEX/MATCH, wrap it with IFERROR to display a custom message.

Can I change the starting date later?

Yes. Change the value in cell F1. The running-total helper column recalculates, and the lookup formula automatically returns the new first qualifying date.

Do I need to sort dates in ascending order?

Yes. Keep the Date column in ascending order so the running total accumulates chronologically from the selected start date.