Help with Formula

[gyagos]

I have the following formula to combine # of days in column Q to months. The issue is that the day range for the highlighted (<366) is not working. All the days that are within 331-365 are coming back as ?NAME. What would be the cause as i cannot figure this out



=IF(Q2<31,"1 Month",IF(Q2<61,"2 Months",IF(Q2<91,"3 Months",IF(Q2<121,"4 Months",IF(Q2<151,"5 Months",IF(Q2<181,"6 Months",IF(Q2<211,"7 Months",IF(Q2<241,"8 Months",IF(Q2<271,"9 Months",IF(Q2<301,"10 Months",IF(Q2<331,"11 Months",IF(Q2<366,”12 Months”,"1+ Years"))))))))))))

Thanks in advance

 

[Joe4]

Excel is very particular.
Note in the errored section, you are using slanted double-quotes. You are using straight ones everywhere else.
Excel like the straight ones, not the slanted ones.

 

[gyagos]

well what do you know
redid the quotes and it works. Thanks for the quick response and solution

 

[Joe4]

You are welcome.
Glad I was able to help!