Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Continuing days of the week and dates

Copper Contributor

Screenshot 2023-12-08 093358.png

 

 

I am trying to continue the days of the week, number of weeks, and dates. If someone knows a simpler way to do this please let me know! I got the original dates and weeks from a template.

1 Reply

@kelly_Ev2 

This formula will produce a calendar with the arrangement displayed in your screen cap:

 

 

=LET(
    start, DATE(2024, 1, 1),
    dates, SEQUENCE(, 366, start),
    day_of_week, TEXT(dates, "ddd"),
    month_name, IF(day_of_week = "Sat", TEXT(dates, "mmm"), ""),
    week_num, IF(day_of_week = "Sat", "Week " & WEEKNUM(dates), ""),
    day_num, DAY(dates),
    VSTACK(week_num, month_name, day_of_week, day_num)
)

 

You can change the start date and adjust the number of dates. In the above, it's using 366 dates.