<aside>
⚠️ Change lowercase w
to uppercase W
if your weeks start on Monday.
</aside>
prop("Date") ? ((formatDate(prop("Date"), "E") != "7") ? ("Week " + formatDate(prop("Date"), "w") + " (" + formatDate(dateSubtract(prop("Date"), toNumber(formatDate(prop("Date"), "E")), "days"), "D MMM –") + formatDate(dateSubtract(prop("Date"), toNumber(formatDate(prop("Date"), "E")) - 6, "days"), " D MMM)")) : ("Week" + " " + formatDate(prop("Date"), "w") + " (" + formatDate(prop("Date"), "D MMM –") + formatDate(dateAdd(prop("Date"), 6, "days"), " D MMM)"))) : ""
<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 Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>