5 week rotating menu

[frankikoch]

Good evening, I have a table with food menus that span 5 weeks. I would like that automatically once the 5 weeks have passed, week 1 would start again, all the weeks that could be put from the calendar view

[Joseph_Seddik]

I understand your requirement as follows:

• You have 35 menus, one menu per day.
• Each day, you want to serve a different menu in order from your 35-menu list.
• Once you have served all 35 menus at the 35th day, you want to start over at the 36th day and start again serving menu number 1.
• So the question basically is: what is the menu I should serve today? 

This is what you should do:

1. Your Menus table should have a "menuID" column of type Number. This should be your key column, and should have the values from 1 to 35. 
   
   
2. You should have a fixed reference date for the first ever meal to be served. Let's consider this date as "01/01/2022". You can put any date you like, just make sure you use the "mm/dd/yyyy" date format. 
   
   
3. Use this formula to find the [menuID] that corresponds to [date]. 
   
   MOD(
     INDEX(
       EXTRACTNUMBERS( TEXT([date] - "01/01/2022") ),
       1
     ) / 24,
     35
   )

[frankikoch]

Actually, the structure of the menus would be first week  from Monday to Sunday lunch and dinner, second week  also from Monday to Sunday lunch and dinner, and so on until completing the 5 weeks that would actually be 70 menus because there is noon and night.

[Joseph_Seddik]

Please show detailed screenshots your tables and their column configurations. 

[frankikoch]

And where should I put the formula so that with a weekly calendar view, when pressing the corresponding day, the lunch menu and the evening menu are displayed?

[Joseph_Seddik]

To be able to answer your question, please show detailed screenshots of your tables and their column configurations. 

[frankikoch]