<!-- https://learnsql.cpetoday.com/functions/m/date-addquarters -->
# Date.AddQuarters

Language: Power Query M
Category: Date
Syntax: Date.AddQuarters(dateOrDateTime as any, numberOfQuarters as number) as any
Summary: Adds a number of quarters to a date, where one quarter is three months.
Returns: The new date, or null when the input is null.
Level: Intermediate
Related: Date.AddMonths, Date.AddYears, Date.StartOfQuarter, Date.EndOfQuarter, Date.QuarterOfYear

## What it does
Date.AddQuarters moves a date by whole quarters. A quarter is three months, so the result is the same as adding three times the number of quarters with Date.AddMonths. It suits quarterly schedules such as estimated tax payments, quarterly rent and quarterly covenant tests.
## Syntax and arguments
- dateOrDateTime: the starting date or datetime.
- numberOfQuarters: the number of quarters to add. A negative number goes back.
## Example
A company pays estimated tax in quarterly installments. The payment dates are set from the first installment date in the year, one every three months.

```powerquery
let
    FirstInstallment = #date(2026, 4, 15),
    Installments = List.Transform({0..3}, each Date.AddQuarters(FirstInstallment, _)),
    AsTable = Table.FromList(Installments, Splitter.SplitByNothing(), {"DueDate"}, null, ExtraValues.Error)
in
    AsTable
```

The four dates are April 15, July 15, October 15 and January 15, 2027. Each is three months after the one before, and the day of the month stays the same.
## Example: a second, different use
Find the date three quarters after a contract start to set a review date.
## Things to watch
- A quarter is three months, not a calendar quarter. Starting on April 15 gives July 15, not the quarter end.
- The same month end rule as Date.AddMonths applies, so a start on the 31st can move to a month end.
- Use Date.StartOfQuarter or Date.EndOfQuarter when the schedule is tied to the calendar quarter.
- Null in gives null out.
## In business terms
Quarterly tax deposits, rent and covenant reviews are scheduled in quarters. Generating them from one start date keeps the whole year's schedule consistent and easy to check against the agreement.
