Formula between dates

[Ramsey_Stonebur]

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!

[Emma_Sousa]

Hi

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

Emma