Next Date in Formula?

Hello all,

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!


Curious - did you ever figure this out? I’m looking to do something similar.


This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.