Ben SmithBen Smith
Ben Smith/
Weekly Dates
Weekly Dates
Weekly Dates

Weekly Dates

For
Tobias
From
Facebook
Status
Updating
Formulas
empty
empty
formatDate
formatDate
if
if
Share
💡
Use Week Column Output for Titles: click and drag on the Week column to select the cells and copy them, then select the same rows in the Name column and paste.
2020 Weeks

Week

⚠️
Change lowercase w to uppercase W if your weeks start on Monday.
empty(prop("Dates")) ? "" : ("Week " + formatDate(prop("Dates"), "w"))
empty(prop("Dates")) ? ""
If Dates is empty, display nothing.
: ("Week " + formatDate(prop("Dates"), "w"))
Otherwise display Week and week number.
 
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!