Hi,
I have a simple worksheet containing job review data, the columns relevant to this question are the 'Date Completed', 'Month' and 'Performance Review'

Column F = Date Completed contains a date (dd/mm/yyyy) that the job was completed.
Column H = Performance Review contains a percentage that was given for the performance review.
I also have a seperate sheet containing each date within the month which I have then created name ranges for, refJAN, refFEB, refMAR etc.

This is the code I have been using in the first row of data (row 2);

[=IF(F2=refJAN,"JAN",IF(F2=refFEB,"FEB",IF(F2=refMAR,"MAR",IF(refAPR,"APR",IF(F2=refMAY,"MAY",IF(F2=refJUN,"JUN",IF(F2=refJUL,"JUL",
IF(F2=refAUG,"AUG",IF(F2=refSEP,"SEP",IF(F2=refOCT,"OCT",IF(F2=refNOV,"NOV",IF(F2=refDEC,"DEC","ERROR")))))))))))) + CTRL + SHIFT + ENTER]

I have placed the word "ERROR" as the last false statement to ensure the entire statement is being run.
Now if the date in column F is the 1st of the month it will return the correct value, but any dates past the 1st return with "ERROR".

The name range cells are also in the dd/mm/yyyy format, I obvioulsy have to do some sort of range statment when refering to the name ranges, but not sure how to do this.

Appreciate the help.