| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
between dates
Hello,
I have the following information: Ope Date Ammount Start Date End Date 09/11/2006 5.000 09/11/2006 09/11/2007 In the first year you charge 4.50% If I need to muply the ammount with the %change IF the operation date is between the start and the end date, haw should I write the formula? IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnĀ“t work! Please help as soon as possible! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying unique dates in a row of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Dates showing are not what I type | New Users to Excel | |||
| formula to add dates. | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Threaded Mode
