Choosing todays date but getting the info from the next cell

[shaftdx]

I have 2 worksheets one has a list of the dates this month going down in Column A. Column B has a list of names that rotate So for today Carla is on call. tomorrow will be john Ect ect till the list is complete and starts over.

Without getting too technical I have a Zapier that adds to the group calendar who is on call from the second worksheet. What I am looking to do is to automate this.

So basically what I am looking to do is tomorrow when that date is highlighted I want the date and the first name on the list next to it to appear in B2 and D2 of the second pic. and when it is thursday Maria will appear in D2 I feel like I am explaining this poorly I am sorry

 

[jasonb75]

Assuming sheet1 at the top,

=INDEX(Sheet1!$B$3:$F$12,MATCH(INT($B2),Sheet1!$A$3:$A$12,0),MATCH(D$1,Sheet1!$B$2:$F$2,0))

Note that as you have asked in the Excel questions section, I have provided an Excel formula. Your screen capture appears to be google sheets, the formula may work but I can not guarantee it.

 

[shaftdx]

Assuming sheet1 at the top,

=INDEX(Sheet1!$B$3:$F$12,MATCH(INT($B2),Sheet1!$A$3:$A$12,0),MATCH(D$1,Sheet1!$B$2:$F$2,0))

Note that as you have asked in the Excel questions section, I have provided an Excel formula. Your screen capture appears to be google sheets, the formula may work but I can not guarantee it.

Thank you i will give it a shot tomorrow when i go back in