Help

Week start monday rather than sunday?

Topic Labels: Formulas
548 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alix
5 - Automation Enthusiast
5 - Automation Enthusiast

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
0 Replies 0