OK, so how do I incorporate this code....

=RIGHT(CELL("filename"), LEN(CELL("filename"))-FIND("]",CELL("filename")))

into or with this code....

=IF(INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A70")<FALSE,INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) & "'!A70"),"")

Because if I just copy/paste it it doesn't seem to work. So I am wondering
where I use the suggested code?

Thanks Much.
Rob