Downloads
Power Query MDateIntermediate

Date.AddQuarters

Adds a number of quarters to a date, where one quarter is three months.

Syntax
Date.AddQuarters(dateOrDateTime as any, numberOfQuarters as number) as any

Returns: The new date, or null when the input is null.

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

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.

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

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.

Related functions

All Power Query M functions · View as Markdown · M basics