MONTH function

[Charlie]

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

 

[Per Jessen]

Hi

Try this:

=IF(cell="","NA",IF(ISNA(VLOOKUP(MONTH(cell),LookupMonth,2,FALSE)),"NA",VLOOKUP(MONTH(I12),LookupMonth,2,FALSE)))

Regards,
Per

 

[Charlie]

Thanks Per. Works a dream. You're a star.

Hi

Try this:

=IF(cell="","NA",IF(ISNA(VLOOKUP(MONTH(cell),LookupMonth,2,FALSE)),"NA",VLOOKUP(MONTH(I12),LookupMonth,2,FALSE)))

Regards,
Per