Excel 2007 : Assistance with creating a specific formula in MS Excel 2007 or higher?

Hello, I'd like assistance with creating a formula in Microsoft Excel (2007 or higher) that will provide the following result, based on data which I specifically enter:

If I saved $1 per day within the date range of 14 September 1989 to 21 June 2012, how do I create a Microsoft Excel formula for this?

Note, the date range above is just an example.

Any assistance will be greatly appreciated.

Thank you for your time.

Welcome to the forum.

You can use: =(date2-date1)*amount

use cell references for date1, date2 and amount
and format the cell with the formula as currency

To Cutter and all

Thank you for your assistance to my original post; however, I'd like to apologise that my request for assistance might have been ambiguous - judging by the response.

Let me rephrase my original question:

Using MS Excel 2007 or higher, I want to create a formula that will calculate savings based upon $1 per day indefinately. How do I do this?

The date range used in my original question was there for an example - let me explain...

If I had (past tense) saved $1 per day (I get paid fortnightly, so $14 over two week intervals), starting from 14 September 1989 continuously for the rest of my life including today, 21 June 2012, and beyond... not including any bonus interest or anything else accumulated over time, how much money would I have today (use today's date)? Help me create a formula to show this, please. Maybe show me an example of what the formula could look like???

Thank you. I look forward to your reply.

OK, I'll be more specific.

In cell B2: input your date of Sep 14/89
In cell C2: type =TODAY()
In cell D2: type 1 and format as currency
In cell E2: type =(C2-B2)*D2 and format as currency
you'll get a result of: $8,316.00

Thank you Cutter

I never doubted that your advice wouldn't work; I just needed to see it in action.

Again thank you.

You're welcome.