| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statements with more than one date column
I have a workbook with date and description data. I have tried multiple
formulas like this one and get #values or name... =IF(('Master Sheet'!G4=I$2,'Master Sheet'!G4<=J$2),'Master Sheet'!G4,"")*IF(('Master Sheet'!I4=I$2,'Master Sheet'!I4<=J$2),'Master Sheet'!I4,"") MS G-4 and MS I-4 are dates I-2 is the lower date and J-2 is the higher date. "To make it simple I want the items due in Jan. to show up and all other data to be blank" This information is on a second worksheet in the same workbook. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| How do I use 3 separate column qualifiers to sum? IF statements? | Excel Worksheet Functions | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Threaded Mode
