Value week number

[Cannone_Cannone]

HI EVERYONE!!
A small problem to solve, I have a column with Italian date value 21/12/2021. I would like that in a column called week, it automatically gives me the number of the current wk example “50”. I tried with WEEKDAY ([Data]) but it gives me value “3”

[Suvrutt_Gurjar]

Please use WEEKNUM() function

help.appsheet.com

WEEKNUM()

Week of year from Date or DateTime

[Cannone_Cannone]

i’m sorry but i try the formula WEEKNUM(TODAY())
In the colum data i have this value 21/12/2021 the result is “52”

[Suvrutt_Gurjar]

Yes, that is correct as per the AppSheet WEEKNUM() expression.

[Cannone_Cannone]

Thanks!!!

[Cannone_Cannone]

OK as a result I should have week 51 not 52

[Suvrutt_Gurjar]

Please take a look at the below post thread. Different systems/standards follow different week number calculations. Please explore if any of the options mentioned below work for you.

WEEKNUM() Discrepancy | Depends on your Locale Tips & Tricks 💡

While troubleshooting an issue with WEEKNUM(), I came across a curious fact that I thought I would share. The internet, or at least the websites you’d go to for answers if you Googled something, don’t count the first incomplete week of the year when figuring week numbers. Which means if you’re in the US (among a few other countries) and searched the internet to find out what week number it was… the numbers would be wrong (from your perspective). Assume that for this discussion, Sund…

[Marc_Dillon · Accepted solution]

ISOWEEKNUM() exists now. Try that instead.