Skip to main content

Week start monday rather than sunday?

  • September 8, 2023
  • 0 replies
  • 123 views
A
Forum|alt.badge.img+5

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

Terms & ConditionsAccessibility statement