Is there a way to update a date based on weeks instead of a number of months? The only one I can find is .RelativeDate which goes based on months. I have an amount that updates every 2 weeks instead of the same day every month. Any idea how to do that? I’ve got a calendar view of a table and when I pay the amount I want it to update to the next month (I’ve got the buttons in place to update the dates but clearly, only to the next month for the same date)
Will adding 14 days not work?
I assume there needs to be a formula for months, because it can be 28, 29, 30 or 31 days. But weeks are always 7 days.
The end of the month date can be found by finding the next month minus 1.
Every month starts at the 1st. and it doesn’t matter which month is the previous month when you deduct 1 day, you will always end up with the last day of that month
The last sample in this doc, explains in more detail.
This is one of the reasons I like Coda soooo much, and you learn to think in a different way to solve challenges in life