Ben SmithBen Smith
Ben Smith/
Weekly Filtering
Weekly Filtering
Weekly Filtering

Weekly Filtering

For
From
Status
Updating
Formulas
+
+
dateSubtract
dateSubtract
formatDate
formatDate
if
if
toNumber
toNumber
!=
!=
Share
Entries

Week Range

⚠️
Change lowercase w to uppercase W if your weeks start on Monday.
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)"))) : ""
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!