WEEKNUM() day

[1minManager]

For WEEKNUM(), does a week begin on Sunday or Monday? The help page doesn’t specify and I’ve got a Report running on Sunday at 1200 that checks if a record has already been created manually.

help.appsheet.com

WEEKNUM()

Week of year from Date or DateTime

[JuneCorpuz]

WEEKNUM() shows the week number not the number for a specific day

help.appsheet.com

WEEKDAY()

Day of week from Date or DateTime

[1minManager]

Let me put it another way

Is Sunday 25th Oct 2020 in week 43 or week 44?

As WEEKDAY() has Sunday as day 1

[JuneCorpuz]

Week 44

[1minManager]

So WEEKDAY() starts on a Sunday and WEEKNUM() Starts on a Monday

[JuneCorpuz]

WEEKNUM() starts on a sunday. See screenshot below