| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding a column based on greater than a date
I am trying to add a column (Col. A) based on a date (Col. B). I want
to add Col. A if Col. B is within the next 30 days of today's date (which I've put in Col. C). The formula I've tried is: SUMIF(A,"BC AND B<=C") but it doesn't work. Any ideas about what I'm doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| LINK ONE ROW BASED ON CONTENTS OF A COLUMN WITHIN THE ROW (DATE) | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| Show a date based on today | Excel Worksheet Functions | |||
Threaded Mode
