Hi,I've dates like2022-06-06,2022-06-13,2022-06-20,2022-06-27 and similarly for all the months.I need to show that as2022-06-06 1st week2022-06-13 2nd week2022-06-20 3rd week2022-06-27 4th week
How does this look? I've included a whole week in my example so you can see it working for any day of the week.
Hey @Ronal_bal are you really precious about that format? Or would something like the output below work? I'm not aware of any easy way to add the cardinals without a massive bruteforce if statement, though I may just be missing something! I just added the sort tool in case there's a chance some dates aren't in order - if it's not needed then obviously just delete it.
Ok never mind, it wasn't actually too bad! Updated workbook attached.
I need similar to thisFormula : 'Week '+ datetimeformat([Date],'%A')for the input 2022-06-16 output is week 24 for the above formula.which will give the week number. But also the date the week starts with (i.e. Monday)something like this for the input 2022-06-16. expected output can be 2022-06-16 week-2. andfrom the next month it can be like 2022-07-04 , expected output 2022-07-04 week-1
So you want to see what week of the month it is? Does this work?
If not, can you give a bit of a clearer description on the logic?
Formula : 'Week '+ datetimeformat([Date],'%W')The above formula provides me the week number in a year (0-52). for example 2022-06-17, the output is week 24.With week 24 as output , I need that date on which I calculates the week number.In this case, its calculation on Monday of every week as starting date of week2022-06-17 - input2022-06-13 week 24 - expected output, because June 13 is the beginning of this week. which I needed in the output along with week number.
