| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MONTH function
How do I get around the MONTH(cell) function returning 1 (Jan) when evaluated
against what I consider to be an empty date cell? I'm using it within ... IF(ISNA(VLOOKUP(MONTH(cell),LookupMonth,2,FALSE)), "NA",VLOOKUP(MONTH(I12),LookupMonth,2,FALSE)) I was expecting it to return NA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
| =Month function in Excel gives incorrect month | New Users to Excel | |||
Threaded Mode
