2

In sheet1 (Source), I've a full calendar containing datas (dates in same row)
On 30/10/2022 in AM, SHIFT 1 has to work with ITEM A
On 30/10/2022 in PM, SHIFT 2 has to work with ITEM B... etc see snapshot below

enter image description here

In sheet2 (Results), I want to retrieve only the datas of only today and tomorrow
I used this formula for today: =filter(Source!$B1:$G21,Source!$B1:$G1=TODAY())
and this one for tomorrow: =filter(Source!$B1:$G21,Source!$B1:$G1=TODAY()+1)

But as you see in the snapshot below, there's only datas of the 1st column which are retrieved!!!! enter image description here

Do u have an idea for showing whole datas, not only 1st column?

I share my work here: https://docs.google.com/spreadsheets/d/1R49vFfk_L_tIOXm3q9dVGzwgHaSFde0Y3BHYGZokHlg/edit?usp=sharing

Thanks in advance Bazu

1 Answer 1

1

In b2 you can use this formula!

=INDIRECT("source!R2C"&match(b1,source!$a$1:1,0)&":R5C"&match(b1,source!$a$1:1,0)+2,FALSE)

This way you're referring with Indirect to the range according to the match of the date!

3
  • This is for today. You can change +2 with +5 for the adjacent day
    – Martín
    Commented Oct 30, 2022 at 20:12
  • Thanks a lot @Martin, it does the job!
    – Bazu
    Commented Oct 30, 2022 at 21:40
  • Great! I'm glad!
    – Martín
    Commented Oct 30, 2022 at 21:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.