Week number based on month start date and month end date

[jlix]

Good morning Community, 

I've trying to get the year week number based on the start and the end of the month date. I have the following columns: start, end, month. The start and end date indicate the range date for the column month. For instance there are ending dates that end in the next month but belong to January for example. here is an example of the table. However, if the week number is based on the date column I will end up with week 53 when the month reference is January so I want the week number to mach the month column so it is consistent. I hope I made sense 🙂 

I  appreciate any help you might be able to provide.  Also if you have any other idea how to approach this please share them the column that are required tho are month, start and end

[dufoq3]

Hi @jlix, could you provide sample data in usable format (if you don't know how - read note below please) and also expected result based on sample data?

[lbendlin]

I've trying to get the year week number based on the start and the end of the month date. 

Those things are violently incompatible.  Use an external Calendar tabe that has all the required details.