Formula for building a weekly schedule, using week ending dates only

Question

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 that matches G3. But I can't get it to repeat until the end date.

Should I change formulas? Can this one be edited to pick up end date?

Thanks

Tina

patrick2788 · Answer

Tina_G1620&nbsp;This is a 365 solution. I've set up a few dynamic items so you can add more data and it will update.&nbsp;=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 &gt;= first_date, weekly_date &lt;= second_date), job, "")
        )
    ),
    MAKEARRAY(height, width, GetJobs)
)&nbsp;