| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select date in date range
I want to be able to do the following:
A B 1 26/03/2006 $20.00 2 1/12/2006 $40.00 3 1/10/2007 $100.00 4 5 6 7 28/11/2006 2 8 29/11/2006 2 I need a formula that says if the date in A7 is between date in A1 to A2, then muliply B7 by B1, else if the date in A7 is between date in A2 to A3, then multiply B7 by B2, and so on. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum select cells based on date range | Excel Worksheet Functions | |||
| Select data to appear on 2nd sheet by date range... | Excel Discussion (Misc queries) | |||
| Select a Range of column depending on the date | Excel Worksheet Functions | |||
| select date range in column | Excel Worksheet Functions | |||
| date criteria to select range | Excel Worksheet Functions | |||
Threaded Mode
