| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a date range in a formula to pull info to the correct column
I have a spreadsheet set up with a column (a) with cost; (b) bill date and 12
columns for each month. I need a formula that will pull (a)the cost into the correct month column based upon (b)the bill date which would be within the range 1/1/07-1/31/07, etc for each month. I tried so many different formulas but non seem to work... =if (b) =1/1/07&1/31/07, (a),0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| date formula | Excel Discussion (Misc queries) | |||
| Mileage Claim Formula | New Users to Excel | |||
| insert date | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Threaded Mode
