This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
This formula is very handy
DATETIME_PARSE({WEEKNUM}&’’,‘w’)
however I need the first day of a work week to be and Monday and the last day of the workweek be Sunday
How can I modify this formula?
Assuming {WEEKNUM} field is using the WEEKNUM() function:
WEEKNUM(date, [startDayOfWeek])
Returns the week number in a year. You may optionally provide a second argument (either “Sunday” or “Monday”) to start weeks on that day. If omitted, weeks start on Sunday by default. Example:
WEEKNUM(TODAY(), “Monday”)
Otherwise, try using the ISO format for week, which starts on Monday. Instead of 'w' it would be 'W'