Forum Discussion

kelly_Ev2's avatar
kelly_Ev2
Copper Contributor
Dec 08, 2023

Continuing days of the week and dates

 

 

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.

excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Dec 08, 2023

    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.

Resources