Weeknumber Issue

[Vince_Balsamo]

Hoping you all may be able to figure out my weeknumber issue. I partner with Amazon and their weeknumbers follow a slightly odd convention where weeks start on Sunday and the first week of the year starts on a Sunday. Below is a screenshot of white my doc spits out for Both ISO and WEEKNUMBER formula’s and what I would like it to say instead (Desired WeekNumber) which I entered in manually. What is the best way to get coda to match the desired result formulaically.

Thanks

[Jean_Pierre_Traets]

Dear @Vince_Balsamo ,

I think that this post will give you a detailed explanation, thanks to the effort of @Christiaan_Huizer

How to get the corresponding month name from a weeknumber?

bonsoir Xavier, There are various ways to obtain the result. The easiest is maybe that you go to this page and take all the values for the year 2021 (all dates, etc) via a filter you check the month that relates to the week number you could get an error message, this is a bug Coda is aware off and they plan to fix it. If you want to generate a table like this it is rather easy. Create two tables as below and use the formula as given. [image] Sequence(thisRow.from,thisRow.to).FormulaMap(…

[Susan_M_Davis]

You can now go into your regional settings and change the starting day of the week in your doc. So if you changed your doc starting day of the week to Monday like Amazon does, then you just need to subtract 1 from every week. Of course week one would be wrong so you could use a simple if statement to fix that If(WeekNumber(thisRow.Date)=1,52 ,WeekNumber(thisRow.Date)-1 )