Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Oct 28, 2021 07:16 AM
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?
Oct 28, 2021 10:35 AM
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'