Tricky Question with the 'Cell Function'

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?

ADDRESS() returns a text value. Since INDIRECT returns a reference specified by a text string, you can have the following...

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

Hope this helps!

Works Perfectly!!

Thanks Alot!