Forum Discussion

MCarmassi's avatar
MCarmassi
Frequent Visitor
3 years ago
Solved

Calendar table can't contain date outside its range

Hello you all.    I am making a calendar table with the calendar function just like   DateTable=CALENDAR(DATE(2023,01,01),DATE(2023,12,31))     Then I want to associate to every date in this...
Show and Tell
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

     

    WeekStart = [Date]-WEEKDAY([Date],2)+1

EndStart = [Date]-WEEKDAY([Date],2)+7

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.