How to get the corresponding month name from a weeknumber?

Showcase Tips and Hacks
5

Sequence(thisRow.from,thisRow.to).Filter(CurrentValue.WeekNumber() = thisRow.weeknumber).FormulaMap(CurrentValue.Monthname())

it is the column you use to enter manually the ‘weeknumber’

image
image1548×1045 28.4 KB

I need to add something and this is that the Coda weeknumbers are based on USA standards and their week starts on Sunday

the IsoWeekNumber() is the version starting on Monday and this one you might prefer :slight_smile:

Sequence(thisRow.From,thisRow.to).Filter(CurrentValue.IsoWeekNumber() = thisRow.Weeknumber).FormulaMap(CurrentValue.Monthname())

hope it helps to get you started this week!
Christiaan

1 Like