How to extract study day status from Numbers calendar cells?

Question

How to extract study day status from Numbers calendar cells?

I'm kind of new to Apple Numbers and I'm facing the following problem. I have created a three months calendar with three different tables to plan the day I'm going to study for my exams:

Each cell that contains the day of the month is a "day only" cell, and under each of them there's a cell in which I wrote the letters "y" (for a yes day for studying), "n" (for a no day) or "h" (for a half day); or either "review" or the name of the exams. What I want to do is, by searching in the calendars cells, to find which letter is written under the current day, in order to know how many pages I have to study that day.

MacBook Air 13″, macOS 26.2

Posted on Dec 15, 2025 4:40 AM

Reply

Answer 1

Badunit

Level 7

30,366 points

Dec 15, 2025 8:29 AM in response to giacomobaratella

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?

Reply