DATE Formula

[srizki]

I am trying to calculate total rent payments.
I have two dates, the starting and ending dates, in column L and O, and need to calculate total rent for that period.
So for example starting date 02/28/08 and ending date 9/1/08. for mula calculates 180 days or 6 months. I multiply that 6 months by rent $1247. the answer is $224,460, obviously that is wrong, the multiplication formula readidng month as date. DATEDIF formula does not work either, for example it calculates one month, of staring date 7/1/08 and ending date 8/31/08.
How can I use months as numbers rather than dates to get correct answer.

Also some tenants moved in in the middle of the month, what formula will give me the total number of days. say 4.2 monts or something like that to calculate the rent.

Thanks

 

[Flue]

Use DateDif

ex. C1 =DATEDIF(A1,B1,"M") ' A1 = 2/28/08 B1 = 9/1/08 M is interval in Months. In your example 6.

Change the interval ("M") to ("D") to get number of Days.

 

[srizki]

the rent $1247 is per month that will multiply number of days times 1247

 

[Aladin Akyurek]

A possible option...

A2: Start date

B2: End date

C2:

=(MonthlyRent*12)*YEARFRAC(A2,B2)

 

[srizki]

Thanks Aladin.

 

[Flue]

Sorry, missed the DateDif in your previous post.