exel 2002 total accumulated payments

[anon125]

i need to know what is the toal of monthly payments i have made
i have forgotten how to include a spreadsheet on this forum post!
thanks all

<colgroup><col style="mso-width-source:userset;mso-width-alt:2560;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:3072;width:81pt" width="108"> <col style="width:60pt" width="80" span="2"> </colgroup><tbody> [TD="width: 90"]

<colgroup><col style="mso-width-source:userset;mso-width-alt:2560;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:3072;width:81pt" width="108"> <col style="width:60pt" width="80"> </colgroup><tbody>
[TD="width: 90"][/TD]
[TD="width: 108"][/TD]
[TD="width: 80"][/TD]

today
ist payment
days
months
mort pymt
spent so far

[TD="width: 108"]mortgage[/TD]
[TD="width: 80"][/TD]
[TD="width: 80"][/TD]

[TD="class: xl24, align: right"]8-Nov-19[/TD]
[TD="align: right"]43777[/TD]

[TD="class: xl24, align: right"]1-Aug-19[/TD]
[TD="align: right"]43678[/TD]

[TD="class: xl25, align: right"]99.00[/TD]
[TD="class: xl24"]'=+B3-B4[/TD]

[TD="align: right"]3[/TD]
[TD="class: xl24, colspan: 2"]'=TRUNC(+B5/30,0)[/TD]

[TD="align: right"]1000[/TD]
[TD="class: xl24"][/TD]

[TD="align: right"]3000[/TD]
[TD="class: xl24"][/TD]

</tbody>

[/TD]
[TD="class: xl22, align: right"][/TD]
[TD="align: right"][/TD]

[TD="class: xl22, align: right"][/TD]
[TD="align: right"][/TD]

[TD="class: xl23, align: right"][/TD]
[TD="class: xl22"][/TD]

[TD="align: right"][/TD]
[TD="class: xl22"][/TD]

[TD="align: right"][/TD]
[TD="class: xl22"][/TD]

[TD="align: right"][/TD]
[TD="class: xl22"][/TD]

</tbody>

 

[Dave Patton]

Excel 2010
	A	B
1
2	Today	08-Nov-2019
3	First payment	01-Aug-2019
4	Payments	3
5
6	Amount	$1,000
7	Total	$3,000
2b

Cell Formulas
Range	Formula
B2	=TODAY()
B4	=DATEDIF(B3,B2,"m")
B7	=B4*B6

 

[anon125]

=DATEDIF(B3,B2,"m") what will that do?
will i get whole months or e.g. 3.567 months?
thanks
what i got was...

<tbody>
[TD="width: 108, align: center"]#NUM!
[/TD]

</tbody>

 

[Dave Patton]

As the example shows, Datedif will provide a whole number such as 3.
Please review the formula =DATEDIF(B3,B2,"m") .
N.B. B3 is the earlier date and B2 is the later date.

 

[anon125]

N.B. B3 is the earlier date and B2 is the later date.

AHA now it works!
thanks for your help Dave