Create Weekly and Quarterly Recurring Dates in Excel
Question details
Create a series of recurring bill dates at weekly, monthly, or quarterly intervals.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to plan a budget using a specific billing date as the starting point.
- Observed behavior
- A formula should calculate future due dates automatically and display them in the desired date format.
Enter the last bill date or another starting date in cell A1, and make sure Excel recognizes it as a date. Choose the interval you need: seven days, one month, or three months.
Use formulas to generate recurring bill dates in Excel
Calculate future dates from a specific starting date and extend the series down a column.
In an Excel worksheet, type your last bill date or another starting date in cell A1.
In A2, enter =A1+7 for weekly dates, =EDATE(A1,1) for monthly dates, or =EDATE(A1,3) for quarterly dates.
Select A2 and drag its fill handle down the column to calculate additional recurring dates.
Select the date cells, open Format Cells, and choose a Date format or a custom month-and-year format.

Build a recurring bill schedule in WPS Spreadsheets
Use date arithmetic and EDATE in WPS Spreadsheets to generate weekly, monthly, or quarterly bill dates and format them for your budget.
- 1. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open your existing budget file.
- 2. Enter a starting date: Type the last bill date or another starting date in cell A1.
- 3. Add a recurrence formula: In A2, enter =A1+7 for weekly dates, =EDATE(A1,1) for monthly dates, or =EDATE(A1,3) for quarterly dates.
- 4. Extend and format the series: Drag the fill handle from A2 down the column, then select the results and use Format Cells to choose a date format.

Frequently Asked Questions
Can I use a specific billing date instead of today's date?
Yes. Enter the billing date in A1 and reference it in a formula such as =A1+7 or =EDATE(A1,3). You do not need to use TODAY().
Do I need to calculate the next billing month manually?
No. Enter =EDATE(A1,3) in A2 to calculate a date three months after A1, then fill the formula down for later quarterly dates.
Why does my date formula show a number?
Excel stores dates as serial numbers. Select the result cells, open Format Cells, and choose a Date format to display them as dates.
What happens if a quarterly date falls beyond the end of a month?
EDATE returns the last day of the destination month when that month does not contain the original day. Check the resulting schedule against your billing rules.




