Calculate the Next Plant Watering Date in WPS Spreadsheet
Question details
Calculate each plant's next watering date by adding a seasonal watering frequency to its most recent watering date.

- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- The worksheet stores the last watering date in one cell, separate watering intervals for two seasons, and a defined list of months for Season 1.
- Observed behavior
- The next watering date should use the Season 1 interval when the last watering month is in the Season 1 month list; otherwise, it should use the Season 2 interval.
Confirm that the last watering value is a real spreadsheet date, not text. Enter the Season 1 and Season 2 intervals as whole numbers representing days, and update the month numbers in the formula to match your seasonal schedule.
Use a seasonal IF formula to calculate the next watering date
Use this formula when D2 contains the last watering date, B2 contains the Season 1 interval in days, and C2 contains the Season 2 interval in days.
The formula checks the month of the last watering date. If that month belongs to Season 1, it adds the interval in B2; otherwise, it adds the interval in C2.
In WPS Spreadsheet, place the last watering date in D2, the Season 1 watering frequency in B2, and the Season 2 watering frequency in C2. Enter frequencies as numbers of days.
Select the cell for the next watering date, such as E2, click the formula bar, and enter =D2+IF(ISNUMBER(XMATCH(MONTH(D2),{1,2,4,11,12})),B2,C2). Press Enter.
In the formula, replace {1,2,4,11,12} with the month numbers for your Season 1 schedule. For example, use {3,4,5,6,7,8} for March through August.
Select the result cell, open Home > Number Format, and choose Date so the calculated serial number displays as a calendar date.
Drag the fill handle from E2 down the column to calculate the next watering date for each plant row.

Use MATCH if XMATCH is unavailable in your spreadsheet version
Use this alternative when your installed spreadsheet version does not recognize the XMATCH function.
Track Seasonal Plant Watering Dates with WPS Spreadsheet
WPS Spreadsheet lets you calculate upcoming watering dates with date functions, conditional logic, and fill-down formulas. Create one seasonal formula, format the results as dates, and apply it to every plant in your watering list.
- 1. Create a plant watering table: Open WPS Spreadsheet and add columns for Plant Name, Season 1 Days, Season 2 Days, Last Watered, and Next Watering Date.
- 2. Enter watering dates and intervals: Type each plant's last watering date and its seasonal intervals in days.
- 3. Add the seasonal date formula: Select the first Next Watering Date cell and enter the IF formula that checks MONTH(D2) against your Season 1 month list.
- 4. Format and fill the results: Choose Home > Number Format > Date, then drag the fill handle down to calculate dates for all plants.

Frequently Asked Questions
Why does my next watering date display as a number instead of a date?
The formula result is a date serial number. Select the result cells and choose Home > Number Format > Date in WPS Spreadsheet.
How do I change which months use the Season 1 watering frequency?
Edit the array inside the formula. For example, replace {1,2,4,11,12} with {3,4,5,6,7,8} to use the Season 1 interval from March through August.
Can I use cells for the Season 1 month list instead of typing month numbers in the formula?
Yes. If your Season 1 month numbers are listed in H2:H6, use =D2+IF(ISNUMBER(XMATCH(MONTH(D2),$H$2:$H$6)),B2,C2).
Which season does the formula use when the next watering date crosses into another season?
This formula selects the interval based on the last watering date in D2. If you need to calculate multiple future watering dates, each subsequent formula should evaluate the previous calculated watering date.




