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.
WEEKNUM() shows the week number not the number for a specific day
Let me put it another way
Is Sunday 25th Oct 2020 in week 43 or week 44?
As WEEKDAY() has Sunday as day 1
Week 44
So WEEKDAY() starts on a Sunday and WEEKNUM() Starts on a Monday
WEEKNUM() starts on a sunday. See screenshot below
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |