Hi!
First of all im super new here, so thanks in advance for any help! Normally i would google my self out and figure out a solution but this seemed to conditional in order to find a solution myself.
I've created a roster for my company, and want to create a small overview card of who is working today and on which project. In order to be dynamic, im creating a date picker which should be the base of the variable.
As you can see attached, from G8 till wherever(im creating new months every month
) the working date is listed. In C8 till E13 i've created a small overview card with the people working on that day. However the formula is now static on Row R as you can see in the formula here.
=FILTER(P9:P50;C9=R9:R50)
I want to make it dynamic, where it by default sets todays day and searches for the hit in the roster, then changes the ranges dynamiccaly based on that day. (1-10 is row R9:R50, 2-10 is S9:S50 etc etc)
See dummy file attached.
Thanks in advance!
First of all im super new here, so thanks in advance for any help! Normally i would google my self out and figure out a solution but this seemed to conditional in order to find a solution myself.
I've created a roster for my company, and want to create a small overview card of who is working today and on which project. In order to be dynamic, im creating a date picker which should be the base of the variable.
As you can see attached, from G8 till wherever(im creating new months every month

=FILTER(P9:P50;C9=R9:R50)
I want to make it dynamic, where it by default sets todays day and searches for the hit in the roster, then changes the ranges dynamiccaly based on that day. (1-10 is row R9:R50, 2-10 is S9:S50 etc etc)
See dummy file attached.
Thanks in advance!