#### alexandros6600

##### New Member

Dear Excel fellows,

I would like some help regarding the rental calculation of the amount which is received annually (based on daily charges).

In column A is the start date of the rental

In column B is the annual rent amount

In column C,D,E,F is the cumulative amount which shall be received for every year

eg. For the year 2024 in C2 based on the rental starting date A2, C2=(194 days in 2024)*(10.000,00usd/365=27,4)=5.315,6 usd

In column G is the end date of the rental

In column F is s the cumulative amount which shall be received for the year 2027

eg. For the year 2027 in Cell F2 based on the rental ending date G2, F2= (235 days in 2027)*(10.000,00usd/365=27,4)=6.439,6 usd

If the start date is after one of the depicted years, the total amount should be null eg Cell C3

likewise,

if the end date is before one of the depicted years, the total amount should be null eg Cell F3

For every cell in columns C,D,E,F that a full yearly(365 days period) is charged then it should return the whole annual amount of the Cells in Column B.

Is there a formula that can calculate the above?

I would like some help regarding the rental calculation of the amount which is received annually (based on daily charges).

In column A is the start date of the rental

In column B is the annual rent amount

In column C,D,E,F is the cumulative amount which shall be received for every year

eg. For the year 2024 in C2 based on the rental starting date A2, C2=(194 days in 2024)*(10.000,00usd/365=27,4)=5.315,6 usd

In column G is the end date of the rental

In column F is s the cumulative amount which shall be received for the year 2027

eg. For the year 2027 in Cell F2 based on the rental ending date G2, F2= (235 days in 2027)*(10.000,00usd/365=27,4)=6.439,6 usd

If the start date is after one of the depicted years, the total amount should be null eg Cell C3

likewise,

if the end date is before one of the depicted years, the total amount should be null eg Cell F3

For every cell in columns C,D,E,F that a full yearly(365 days period) is charged then it should return the whole annual amount of the Cells in Column B.

Is there a formula that can calculate the above?