I need to show who is on call today on a calendar

Hi!
I need help
I'm creating a calendar in excel to organize the "on-call" shifts in my work.
Got all the days of the year in the calendar, and beneath every day there are 2 cells with the name of the two people "on call".
I need to show in another 2 cells of the same book (H4 and H5), the names of people "on call" if the day of the year is the same of today's date (H3).

I attach the xls. file
Thanks in advance

Welcome to the forum

In H3:

Formula:

Please Login or Register  to view this content.

In H4 copy/paste the same formula except change the red highlighted "+1" to "+2"

Edit: I forgot to mention that I changed row 7 from numbers to dates - you need to fix this in your real workbook for the above formulas to work.

On 4 July this yields R. San Martin in H2 and C Berrios in H4. I tested a few other dates and it seems to work correctly.

Hope this helps. Let us know.

Named range: Calendar

refers to:

Please Login or Register  to view this content.

Find the row for the current date:

Please Login or Register  to view this content.

Find the current column:

Please Login or Register  to view this content.

report the names:

Please Login or Register  to view this content.

** You need to use valid Excel dates...

Glad that I could help. Thanks for the feedback and marking the thread as solved and the reputation points