calculation of the week

Good afternoon everyone, how are you?

In this calculation, the DAY of Weed should come as 7 but it is showing as 0.

The week should start on Monday and end on Sunday, 1 and 7.

@iCFO You helped me with this calculation in the past, can you help me?

Hi @Gabriel2020

If you use the locale en_GB it should be fine.

1 Like

Using the PT BR or US location does not work like this.

I would like it to be calculated from Monday to Sunday and it is being calculated from Monday to Saturday

Yes, so use a locale which actually does make that calculation which is shown in my example :wink:


Very cool trick. I didn’t know that different Localizations carried different definitions of week starting and ending days.


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.