If your writing is correct, then the result is the due date on the date 1.

Note that in the above formula, long rent 10 month is added to the month value from the lease start date taken with the function MONTH -> (MONTH(C8) +10). The formula finds the due date in terms of the length of the lease per month With these conditions, you can enter the next formula on G8 salt : Then if the due date will be looked for with the length of the lease by month, For example, the data above is for INOVA car rental starting from the rental date 1 for long the rent is 10 month.If your formula is written correctly, the result will be the due date on the date 0.Note that in the above formula, long rent 3 year is added to the year value from the lease start date taken with the function YEAR -> (YEAR(C6) + 3). =DATE(YEAR(C6)+E6,MONTH(C6),DAY(C6)) The formula finds the maturity date in terms of the length of the lease per year

Place the mouse pointer on G6 salt then enter the following formula : if the rent is long 3 year it will get the due date 0.

to calculate the lease maturity date using the annual lease term, for example in the table above, the rental date for Ruko Edelwis is written 0.

In the table above is written for the calculation of the length of the lease in years, long rent in months, and the length of the lease in a matter of days.

From the table above, you can determine when the due date is if the length of the lease has been determined as in the table above.

SUSPENDED which rents out several types of goods and services as follows :Įxample of a rental table that will look for the due date

Create the following report table that shows the rental transaction report by CV.

Here is an example step – usage measures DATE function, YEAR, MONTH, and DAY to look for a due date : The calculation of maturity must have a start date basis, meaning that this start date will be a reference for calculating when the loan or lease term ends (due date). Examples in everyday life – days are entrepreneurs who usually have a rental or savings and loan business.

Fungsi DATE di dalam application Microsoft Excel can be used to analyze or calculate the due date.

Menghitung jumlah data di excel