Creating a Formula with Dates
 

I want the user to put into a cell: Today's date, ie. 10/1/08

Already in another cell will be the Effective Change Date, ie. 6/1/08

The difference there is 4 months.

Here is the formula I need: ((Orignial Price-New Price) * 4 months)

How do I get the 4 months to calculate based on the user inputting todays'
date or on a date of their choice?

Thanks for your help!!

Creating a Formula with Dates
 

If your earlier date is in A1 and later date is in B1 then
=DATEDIF(A1,B1,"m")
will give you the difference in months..

For details see http://www.cpearson.com/excel/datedif.aspx


--
If you find this post helpful pl. choose "Yes"...


"redlilly" wrote:

I want the user to put into a cell: Today's date, ie. 10/1/08

Already in another cell will be the Effective Change Date, ie. 6/1/08

The difference there is 4 months.

Here is the formula I need: ((Orignial Price-New Price) * 4 months)

How do I get the 4 months to calculate based on the user inputting todays'
date or on a date of their choice?

Thanks for your help!!