How to extract study day status from Numbers calendar cells?

If I understood your question, you have another table somewhere that has the current date in a cell and you want another cell in that table to look in your calendar tables and return the contents of the cell for that date? I think that can be done but I don't understand how it will tell you the number of pages you have to study.

If I got that right, you'll have to provide more info if you want a response that fits your spreadsheet exactly (vs something one of us makes up here as an example). Are your calendar tables on one sheet or different sheets? What is/are the sheet names? What does the other table (the one that has the current date and will have the lookup formula) look like?

EDIT: deleted my post. I think I see what to do.

Doing a lookup across more than one table (such as 12 monthly calendars) isn't the easiest thing to do but it can be done. The simpler way would be to have a single 2-column table of every day of the year (dates in column A and the data (y,h,n, review, etc.) in column B). The calendars could auto-populate themselves using formulas that do lookups from this main table and it would be a simple task just look up a date in the main table and get a result. But you probably prefer entering the data into each separate monthly calendar.

Here is my attempt at your problem. I was hoping to come up with something cleaner and easier but this is what I have so far. The screenshot shows the main sheet, just the tables and cells that were required. The monthly calendars are on the Calendar sheet.

Formulas in table "Today's Date"

B3 =YEAR(B1)

B4 =MONTHNAME(MONTH(B1))

B5 =DAY(B1)

B6 ="Calendar::"&B4&" "&B3&"::A:G"

B7 =WEEKDAY(EOMONTH(B1,−1)+1,2)

B8 =WEEKDAY(B1,2)

B9 =ROUNDUP((B5+B7−1)÷7,0)×2+1

Formula in "Today's Objective"

B2 =@XLOOKUP(INDEX(INDIRECT('Today''s Date'::B6),'Today''s Date'::B9,'Today''s Date'::B8),Objectives::C,Objectives::B,"none",match-type)