Year Ranges

Range

lets(
	yr, prop("Date").year(),
	ifs(
		yr.test("1851|1900"), yr,
		yr >= 1800 && yr <= 1850, "1800–1850",
		yr >= 1901 && yr <= 1950, "1901–1950",
		yr >= 1951 && yr <= 2000, "1951–2000",
		yr >= 2001 && yr <= 2050, "2001–2050"
	)
)

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>