In my spreadsheet, the code

=(ADDRESS(5,(MONTH(B6)+6),4))

will equal "L5'

But when I try to reference this in the line

=CELL("contents",ADDRESS(5,(MONTH(B6)+6),4))

I get an error?

But when I manually type it out

=CELL("contents",L5)

It works?

What am a missing?