I am trying to create a “Bill Reminder” of sorts. I have fields for the bill Name, Amount, Frequency, and Date Due. I want to create a “Next Due” date field where I query if the bill is Monthly or Annually and then somehow create a formula that spits out the next date. Using an IF() statement, I’m able to determine if it’s Monthly or Annually and display custom content, but can I use that same IF() statement to then create some kind of additional formula that checks the dates somehow? Any help?
Thanks so much!