CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Tane
Tane

Reputation: 491

Get data from other sheet according to the date

I have a Google spreadsheet with the following information:

enter image description here

The three cells highlighted with green, A1, A2 and A3 get content from sheets D1, D2 and D3 with =Sheet3!D1 -function. Is it possible to update the content according to the date, so when it's Monday D1, D2 and D3 are shown, but on Tuesday, D4, D5 and D6 are shown?

Upvotes: 0

Views: 64

Answers (1)

BHAWANI SINGH
BHAWANI SINGH

Reputation: 729

try this in A1, you don't even have to use Column C in formula

=OFFSET(D1,(WEEKDAY(today(),2)-1)*3,0,3,1)

enter image description here if you want to use Column C then in A1 use

=OFFSET(D1,MATCH(SWITCH(WEEKDAY(today(),2),1,$C$1,2,$C$4,3,$C$7,4,$C$10,5,$C$13,6,$C$16,7,$C$19),C1:C21,false)-1,0,3,1)

enter image description here

Upvotes: 1

Related Questions