| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If formula for date range
I am trying to set up a formula to check milestones which fall between 15 days + or - of todays date using IF. If the result matches I want the true value to be text in another cell. I've come up with the formula to check if it matches today (see below) but am having problems when trying to add in the +/- 15 days. =IF(C17=B26,B17,0) C17 is milestone date B26 is todays date B17 is milestone description I also want to extend this to multiple cells. Any help would be appreciated. -- rediproof ------------------------------------------------------------------------ rediproof's Profile: http://www.excelforum.com/member.php...o&userid=23714 View this thread: http://www.excelforum.com/showthread...hreadid=374135 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to copy last positive number in range of cells | Excel Worksheet Functions | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
| How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions | |||
Threaded Mode
