Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a count of dates by quarter | Charts and Charting in Excel | |||
Creating dates using IF formula | Excel Worksheet Functions | |||
Creating dates using IF formula | Excel Worksheet Functions | |||
Creating dates using IF formula | Excel Worksheet Functions | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel |