Forum Discussion
Formula for building a weekly schedule, using week ending dates only
I am trying to build a schedule based on week ending dates. I am able to get the start date to filter in, but not the end dates. As you can see in G4 it is repeat the job name with a start date tha...
This is a 365 solution. I've set up a few dynamic items so you can add more data and it will update.
=LET(
height, ROWS(Jobs),
width, COLUMNS(WeekOf),
GetJobs, LAMBDA(r, c,
LET(
weekly_date, INDEX(WeekOf, , c),
first_date, INDEX(Start, r),
second_date, INDEX(End, r),
job, INDEX(Jobs, r),
IF(AND(weekly_date >= first_date, weekly_date <= second_date), job, "")
)
),
MAKEARRAY(height, width, GetJobs)
)
That is awesome. Glad you attached a file.
I have a few more questions. Do you mind if I send you a file with examples?
I have a few more questions. Do you mind if I send you a file with examples?
- Not at all. I'd be happy to take a look.
- Sent the file in a message to you.
Thank you very much!- Received.
Thanks.
I will do a research on it.
