| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MONTH function
Hi
Try this: =IF(cell="","NA",IF(ISNA(VLOOKUP(MONTH(cell),Looku pMonth,2,FALSE)),"NA",VLOOKUP(MONTH(I12),LookupMon th,2,FALSE))) Regards, Per "Charlie" skrev i meddelelsen ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MONTH function
Thanks Per. Works a dream. You're a star.
"Per Jessen" wrote: Hi Try this: =IF(cell="","NA",IF(ISNA(VLOOKUP(MONTH(cell),Looku pMonth,2,FALSE)),"NA",VLOOKUP(MONTH(I12),LookupMon th,2,FALSE))) Regards, Per "Charlie" skrev i meddelelsen ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
