Find the Date When Cumulative Growth Reaches a Target in WPS Office Spreadsheets
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.

- 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.
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.
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.
Type the starting date in cell F1 and the required growth target in cell F2.
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.
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 INDEX and MATCH as a Compatibility Method
Use this if your WPS Office version does not support XLOOKUP or if you prefer a formula that works in older workbook formats.
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. Open your workbook in WPS Office: Launch WPS Office Spreadsheets and open the Excel workbook that contains your date and daily growth data.
- 2. Set up input cells: Enter the start date in cell F1 and the required growth target in cell F2.
- 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. 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.

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.




