Formulas > =PDURATION()

How To Use PDURATION() Function in Google Sheets


Returns the number of periods for an investment to reach a specific value at a given rate.

Common questions about the PDURATION Formula include:
1. What does the PDURATION formula do?
2. When should I use the PDURATION formula?
3. How do I calculate the duration of an event using the PDURATION formula?

The PDURATION formula can be used appropriately to calculate the duration of a time period between any two points of time, such as a start date and an end date, or a date in the past and the current date.

Common mistyping of the PDURATION formula can be PDURATN, PDURAITON, PDRATION, PDURTAION. It also includes entering incorrect syntax such as omission of punctuation between function parameters (e.g. leaving out commas) or using non-existent parameters.

Common ways the PDURATION formula is used inappropriately include entering faulty date parameters (e.g. entering a start date that is after an end date), specifying a cell range instead of a single cell for a parameter, and omitting or adding parameters.

Common pitfalls when using the PDURATION formula include forgetting to set the formula to display the desired unit of duration (e.g. years, months, or days). Additionally, miscalculating the difference in time between the start and end dates could result in the usage of the wrong PDURATION formula.

Common mistakes when using the PDURATION formula include leaving out of parameters, using incorrect punctuation, and using faulty date parameters.

Common misconceptions people have with the PDURATION formula include confusing the syntax of the PDURATION formula with that of other similar time related formulas, such as the DATEDIF and DAYS formulas, and assuming that the PDURATION function can be used with any data type, such as numbers.

How To Actually Use PDURATION() in Sheets

PDURATION(rate, present_value, future_value)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the PDURATION() formula:

Use the PDURATION Function

This video show how to use the PDURATION function (a new function in 2013) to quickly calculate the future value (FV) of an investment.

Generate a PDURATION() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.