Shaqada Muddada^(Duration) ee Microsoft Excel waa shaqo maaliyadeed^{(Financial function)} , ujeeddadeeduna waa in lagu soo celiyo soo celinta amniga sannadlaha ah iyada oo la bixinayo dulsaar xilliyeedka ah.

Waa maxay qaacidada mudada Excel^{(Excel Duration)} iyo syntax?

Qaaciddada shaqada Muddadu^(Duration) waaDURATION(Settlement, maturity, coupon, yld, frequency, [basis])

Erayga hawsha Mudada ^(Syntax)waa^(Duration) hoos:

• Dejinta^(Settlement) : Amniga taariikhda la dejinayo. Waa loo baahan yahay.
• Qaan^(Maturity) -gaarnimada : Amniga taariikhda qaan-gaarnimada. Waa loo baahan yahay.
• Kuuban^(Coupon) : taariikhda kuubanka amniga ayaa loo baahan yahay.
• Yld : Wax-soo-saarka amniga sannadlaha ah. Waa loo baahan yahay
• Soo noqnoqoshada^(Frequency) : Tirada lacagta kuubanka sannadkii. Waa loo baahan yahay.
• Saldhig^(Basis) : Nooca maalinta tirinta ee la isticmaalayo. Waa ikhtiyaari.

Sida loo isticmaalo Function Duration^{(Duration Function)} ee Excel

Si aad u isticmaasho shaqada Muddada^(Duration) ee Microsoft Excel , raac tillaabooyinka hoose.

1. Fur Excel
2. Samee miis ama isticmaal miiska jira
3. Ku qor qaacidada shaqada Muddada^(Duration) unugga aad rabto inaad natiijada dhigto
4. Riix Gelida si aad u aragto natiijada

Bilaw Microsoft Excel .

Samee miis ama isticmaal miiska jira.

Ku qor shaqada =DURATION(B1,B2,B3,B4,B5,B6) unugga aad rabto inaad natiijada dhigto.

Kadib riix furaha geli si aad u aragto natiijada.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada DURATION gudaha Excel .

Habka koowaad waa inaad gujiso badhanka fx ee bidix ee sare ee xaashida shaqada ee Excel .

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada hadalka ee qaybta, Dooro Qayb^{(Select a Category)} , ka dooro Maaliyadda^{(Financial )} sanduuqa liiska.

Qaybta Dooro Shaqo^{(Select a Function)} , ka dooro hawsha DURATION liiska.

Kadib dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

Goobta dejinta^(Settlement) , nooca B1 , unugga ka kooban taariikhda dejinta amniga.

Nooca Qaan^(Maturity) -gaadhka nooca B2 , unuggu waxa uu ka kooban yahay taariikhda qaan-gaadhka ee Amniga.

Nooca Kuubboonka^(Coupon) nooca B3 , unugga waxaa ku jira lambarka kuubanka.

Nooca Yld -ga nooca B4 , unugga waxaa ku jira wax-soo-saarka amniga ee sannadlaha ah.

Nooca goobta  Joogtada ah ee ^(Frequency)B5 , unuggu waxa uu ka kooban yahay tirada lacag bixinta kuuban sannadkii.

Kadib dhagsii OK .

Habka labaad waa in la gujiyo tabka^{(Formulas )} foomamka oo aad gujiso badhanka maaliyadeed ee kooxda ^{(Financial )}maktabadda Function^{(Function Library)} .

Markaa ka dooro hawsha DURATION liiska.

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Waa maxay faraqa u dhexeeya taariikhda dejinta^(Settlement) iyo taariikhda qaan^(Maturity) -gaadhka ee Excel ?

Taariikhda dejintu^{(Settlement Date)} waa maalinta iibsaduhu iibsado kuuban, halka taariikhda qaan-gaadhka ay tahay markii kuubanku^(Maturity) dhacayo.

Muxuu Mudada^(Duration) u soo celinayaa qiyamka qaladka # NUM iyo # VALUE gudaha Excel ?

Excel waxa uu soo celin doonaa qiimihii khaladka ahaa # NUM haddi kuubanku yahay <0 ama haduu yld>0 yahay ama haddi inta jeeri tahay 1,2 ama 4 ama hadii degitaanku yahay ≥ qaan gaadh iyo haddi salku yahay <0 ama>4. Shaqada Muddada^(Duration) waxay soo celin doontaa # VALUE haddii amniga iyo qaan-gaadhnimadu ay tahay taariikh aan sax ahayn.

Waxaan rajeyneynaa in casharkan uu kaa caawiyo inaad fahamto sida loo isticmaalo shaqada DURATION ee Excel .

How to use Duration Financial Function in Excel

The Duration function in Microsoft Excel is a Financial function, and its purpose is to return the annual return of security with periodic interest payments.

What is the Excel Duration formula and syntax?

The formula for the Duration function is DURATION(Settlement, maturity, coupon, yld, frequency, [basis])

The Syntax for the Duration function is below:

• Settlement: The security’s settlement date. It is required.
• Maturity: The security’s maturity date. It is required.
• Coupon: the security’s coupon date is required.
• Yld: The security’s annual yield. It is required
• Frequency: The number of coupon payments per year. It is required.
• Basis: The type of day count basis to use. It is optional.

How to use the Duration Function in Excel

To use the Duration function in Microsoft Excel, follow the steps below.

1. Launch Excel
2. Create a table or use an existing table
3. Type the formula for the Duration function into the cell you want to place the result
4. Press Enter to see the result

Launch Microsoft  Excel.

Create a table or use an existing table.

Type the function =DURATION(B1,B2,B3,B4,B5,B6) into the cell you want to place the result.

Then press the enter key to see the result.

There are two other methods to use the DURATION function in Excel.

Method one is to click the fx button on the top left of the Excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Financial from the list box.

In the section Select a Function, choose the DURATION function from the list.

Then click OK.

A Function Arguments dialog box will open.

In the Settlement field, type B1, the cell that contains the security’s settlement date.

In the Maturity field type B2, the cell contains the Security’s maturity date.

In the Coupon field type B3, the cell contains the Security’s coupon date.

In the Yld field type B4, the cell contains the security’s annual yield.

In the Frequency field type  B5, the cell contains the number of coupon payments per year.

Then click OK.

Method two is to click the Formulas tab and click the Financial button in the Function Library group.

Then select the DURATION function from the list.

A Function Arguments dialog box will appear.

What is the difference between Settlement date and Maturity date in Excel?

The Settlement Date is the day the buyer purchases a coupon, while the Maturity date is when the coupon is expired.

Why does Duration return the error values #NUM and #VALUE in Excel?

Excel will return the error value #NUM if the coupon is < 0 or if yld is > 0 or if the frequency is 1,2 or 4 or if settlement is ≥ maturity and if the basis is < 0 or >4.  The Duration function will return a #VALUE if the security and maturity is an invalid date.

We hope this tutorial helps you understand how to use the DURATION function in Excel.

Related posts

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo RANDBETWEEN Function gudaha Excel

• Sida loo isticmaalo shaqada TYPE ee Excel

• Sida loo isticmaalo Excel Hyperlink Function

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo isticmaalo PMT Function gudaha Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida Loo Isticmaalo Shaqada YEARFRAC gudaha Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel