How to set start date to be first Sunday of the year?

[Anonymous]

Currently it works fine because 1st Jan 23 is a Sunday, however next year it will be Monday. How do i make sure that start date within my CALENDAR() function always falls on a Monday e.g. 7 Jan 24 (Sunday)?

[hendraoui · Accepted solution]

Hello,

You can create a new calculated column in the table containing the date column that you want to modify. You can do this by right-clicking on the table and selecting "New column".

Start Date =
DATE(YEAR([Date]), 1, 1) + MOD(8 - WEEKDAY(DATE(YEAR([Date]), 1, 1)), 7)

[Ahmedx]

To be honest, I don't understand what you want.
show me what you want

[Anonymous]

some_date_table = CALENDAR(<start date is first sunday of January every year>, <last sunday of the year; i suppose I could add 364 days>)

How would I go on about doing the first argument?