I want to make a formula that shows when each next day of the week is (I have a database with "Monday", "Tuesday" and so on), so I can filter a view on my dashboard for "(next monday date) is today".
I've set up a start date using the Date property, and been trying to use this as a base:
dateAdd(prop("Start Date"), dateBetween(now(), prop("Start Date"), "day") + 1, "weeks")
The above formula returns the Start Date, but added by a week. I'm wondering if we'd be able to add not just 1 week, but subtract the "now" week and the Start Date property week to find out how many weeks to actually add. I tried it on this next formula but it also doesn't work completely (bugs some dates):
dateAdd(prop("Start Date"), dateBetween(now(), prop("Start Date"), "weeks") + dateBetween(now(), prop("Start Date"), "weeks"), "weeks")
Here's the link to the page I've been working on: https://absorbed-position-c49.notion.site/842f8195a73e4492a5b6b73fd6e94578?v=a80fa07f570b47cb89b8e78cbeb79358
I hope this makes sense lol
Thanks in advance.