Quarterly Planning - Pull Dates

[Jean_Pierre_Traets]

Dear @Kristin_Grimpe welcome to the Coda Make Community,

I am rather sure that this post contains the resources you are looking for:

How to get the corresponding month name from a weeknumber?

good to see you solved this part of the puzzle @Xavier_Rabilloud ! you might want to go even one step further. sometimes you have two months in one week. below the steps to force a choice. [image] [image] and in the last step I make some hard coded choices and these you can put as you see fit. Here is equal or greater than 4 days [image] As always, this can be put into one formula. However to understand the steps, this might be easier to follow. Sequence(thisRow.from,thisRow.to).Filter…

Credits: @Christiaan_Huizer