Thread: MONTH function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default 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