<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> This formula determines the ISO week start of the current year and then adds the number of weeks in the ISO week property to determine a start date for the project. It also creates a date range for the project with a default of four weeks.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Date Range from ISO Week Number

Project Dates Formula:

lets(
	jan4,
	parseDate(now().year() + "-01-04"),
	week1Start,
	jan4.dateSubtract(jan4.day() - 1, "days"),
	projectStart,
	week1Start.dateAdd(prop("ISO Week"), "weeks"),
	dateRange(
		projectStart,
		projectStart.dateAdd(4, "weeks")
	)
)

© Thomas Frank