| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help using the DAY() function
=IF(DAY(B3:B30)21,N4,0) I'm trying to use this formula to check in
column B if a date of the 22nd of the month was entered (manually). If it was, then the cell (O4 in this instance) would be equal to the contents of cell N4, which is a numeric value. Otherwise, cell O4 would be equal to zero (0). The problem I'm having is that the range (B3:B30) is not being checked - it doesn't work. Furthermore, B4 is the only cell that allows this formula to work. Can't figure that one out. Do I need to rewrite the formula? Any help would be appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
