Help

Re: Next Date in Formula?

811 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramsey_Stonebur
6 - Interface Innovator
6 - Interface Innovator

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!

Help me fight a corrupt mortgage company - https://gofund.me/7542ee8b
1 Reply 1
Emma_Sousa
6 - Interface Innovator
6 - Interface Innovator

Hi

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

Emma