Creating a reference to a named range

[Blundellmatt]

I am creating a calendar with each month being it's own sheet. Each day is represented with a named range. I have a navigation sheet that I would like to be able to show today's named range on. I have nt been able to figure out a formula that will associate the name of the range with =today().

 

[My Aswer Is This]

I am creating a calendar with each month being it's own sheet. Each day is represented with a named range. I have a navigation sheet that I would like to be able to show today's named range on. I have nt been able to figure out a formula that will associate the name of the range with =today().

So your saying you have 12 sheets for each month of the year. And each sheet has 30 named cells.

How are these sheets named and how are the cells named. Is the sheet named "January" "February"

etc. And how are the 30 different cells named?