Function Problems

Create Weekly and Quarterly Recurring Dates in Excel

John WilsonJohn Wilson Nov 13, 2026 868 views

Question details

Create a series of recurring bill dates at weekly, monthly, or quarterly intervals.

Create Weekly and Quarterly Recurring Dates in Excel
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.
Before you start

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.

Solution 1Recommended

Use formulas to generate recurring bill dates in Excel

Calculate future dates from a specific starting date and extend the series down a column.

1
Enter the starting date

In an Excel worksheet, type your last bill date or another starting date in cell A1.

2
Choose an interval

In A2, enter =A1+7 for weekly dates, =EDATE(A1,1) for monthly dates, or =EDATE(A1,3) for quarterly dates.

3
Fill down

Select A2 and drag its fill handle down the column to calculate additional recurring dates.

4
Format the dates

Select the date cells, open Format Cells, and choose a Date format or a custom month-and-year format.

Use formulas to generate recurring bill dates in Excel
Check dates near the end of a month: EDATE uses the last day of the destination month if the original day does not exist there. When formulas refer to the previous result, later dates may retain that adjusted day.
Create recurring dates in WPS

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. 1. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open your existing budget file.
  2. 2. Enter a starting date: Type the last bill date or another starting date in cell A1.
  3. 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. 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.
Generate recurring bill dates with formulasOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceGet started with WPS Office for free
microsoft office alternative - wps office

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.