| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return a number from a list of date ranges
Hello,
I have looked and looked and I am now stumped. Help! I want a percentage rate to populate into a cell based on a date entered in another cell. Example info: 07/01/87 - 12/31/94 = 12% 01/01/95 - 12/31/95 = 8% 01/01/96 - 12/31/96 = 10% Date cell A1 Percentage rate cell A2 I type 02/01/95 into cell A1. I would like 8% to populate into cell A2. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return week number from date? | Excel Worksheet Functions | |||
| How to return week number from date? | Excel Worksheet Functions | |||
| return previous date from list | Excel Worksheet Functions | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| Drop down list to return row number? | Excel Discussion (Misc queries) | |||
Threaded Mode
