Ben SmithBen Smith
Ben Smith/
Next Month by Weeks
Next Month by Weeks
Next Month by Weeks

Next Month by Weeks

For
Kim
From
Facebook
Status
Updating
Formulas
dateAdd
dateAdd
formatDate
formatDate
==
==
Share
Entries

Week

⚠️
Change lowercase w to uppercase W if your weeks start on Monday.
(formatDate(now(), "wY") == formatDate(prop("Date"), "wY")) ? 1 : ((formatDate(dateAdd(now(), 1, "weeks"), "wY") == formatDate(prop("Date"), "wY")) ? 2 : ((formatDate(dateAdd(now(), 2, "weeks"), "wY") == formatDate(prop("Date"), "wY")) ? 3 : ((formatDate(dateAdd(now(), 3, "weeks"), "wY") == formatDate(prop("Date"), "wY")) ? 4 : 0)))
 
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!
 
This Week Example

This Week

⚠️
Change lowercase w to uppercase W if your weeks start on Monday.
formatDate(prop("Date"), "wY") == formatDate(now(), "wY")