I want to display the week like a calendar, but this formula is returning week 1 as starting on a sunday instead of a week starting on a monday and finishing on a sunday, how can i alter this?
VALUE(DATETIME_FORMAT(Date,'w'))-
VALUE(DATETIME_FORMAT(
DATETIME_PARSE('01'&DATETIME_FORMAT(Date,'MM')&YEAR(Date),'DDMMYYYY'),'w'))+1