I have a list of expenses that recur each month. I’m trying to figure out how set a date so that if the current date hasn’t reached due date for the expense it stays whatever the date is in the field, but then updates to the next month when the due date passes.
I’ve tried to replicate and modify how I have this set up in Excel/Numbers, but cannot figure out how to translate this in Coda’s language. Here’s the current formula:
IF(DAY(TODAY())≤1,DATE(YEAR(TODAY()), MONTH(TODAY()),1),DATE(YEAR(TODAY()), MONTH(TODAY())+1,1))
Any ideas would be greatly appreciated.