Calculating Dates and multiplying by interest rate?

[JAnderson]

I'm pretty sure there is a way to do this without a macro.

Say I have a table in Word. Cell A1 is a merge field which pulls a begin
date and an end date. Cell B1 is an interest rate. Cell C1 is a dollar
amount. I want cell D1 to calculate interest owed between those dates.

Example:
A1
April 2, 2002 through March 9, 2007
B1
8% interest rate
C1
1000 dollars
D1
(Interest owed calculation)

I know all the fields and variables here; I just can't figure out the date
situation. Any ideas?

 

[Jay Freedman]

I'm pretty sure there is a way to do this without a macro.

Say I have a table in Word. Cell A1 is a merge field which pulls a begin
date and an end date. Cell B1 is an interest rate. Cell C1 is a dollar
amount. I want cell D1 to calculate interest owed between those dates.

Example:
A1
April 2, 2002 through March 9, 2007
B1
8% interest rate
C1
1000 dollars
D1
(Interest owed calculation)

I know all the fields and variables here; I just can't figure out the date
situation. Any ideas?

Have a look at
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902

 

[JAnderson]

This is GOLD. Thank you!

Have a look at
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.