| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logic eludes me
I'm working with date ranges. What I'm looking for is a way to have a cell
given a value on a specific date, and have it remain there thru the remainder of the date range (confused yet?). This is what i have so far: =IF(AND(COUNTIF(Named_Range,G12:AG13)+IF(TODAY()= AG13,0,5)),5,0) At the end of the quarter, this adds my value of 5 into a cell, and then removes it beyond the end of the quarter. What I need is to have the cell at a value of 0 prior to the end of the quarter. (Totally confused now?). I know I am. Help me please, before what little hair I have left if gone for good. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of logic cells | Excel Discussion (Misc queries) | |||
| Logic Tree, MS help = useless | Excel Worksheet Functions | |||
| Logic question | Excel Discussion (Misc queries) | |||
| logic stmt. use in a new workbook w/o refering back to original | Excel Worksheet Functions | |||
| Logic Function Help… | Excel Discussion (Misc queries) | |||
Threaded Mode
