If Statement to calculate date

JohnFesler

Termination form:

Termination Date captured in [Term Date]

[Duration - Phone/Email Forward] single drop down selection 0 days, 30 days or 60 days

I would like a [Disable Forward Date] to be generated based on selection of [Duration - Phone/Email Forward]

Here is my attempted formula/function-

=IF([Duration - Phone/Email Forward]@row = "30 Days", =[Term Date]@row + 30)

Will need to create one for "0 Days" and "60 Days" as well.

Genevieve P.

Hi @JohnFesler

You're close! When you list multiple IF statements, don't close off each IF formula with a closing ) until the very end of the statement... this keeps it open so that if the first statement isn't True, it moves on to read the next statement.

Try something like this:

=IF([Duration - Phone/Email Forward]@row = "0 Days", [Term Date]@row, IF([Duration - Phone/Email Forward]@row = "30 Days", [Term Date]@row + 30, IF([Duration - Phone/Email Forward]@row = "60 Days", [Term Date]@row + 60)))

Cheers,

Genevieve

JohnFesler

Believe I figured it out. No = before [Term Date]@row + 30)

JohnFesler

Am having issues linking multiple statements.

=IF([Duration - Phone/Email Forward]@row = "0 Days", [Term Date]@row + 0), IF([Duration - Phone/Email Forward]@row = "30 Days", [Term Date]@row + 30)

Returns Unparseable.

Genevieve P.

Hi @JohnFesler

You're close! When you list multiple IF statements, don't close off each IF formula with a closing ) until the very end of the statement... this keeps it open so that if the first statement isn't True, it moves on to read the next statement.

Try something like this:

=IF([Duration - Phone/Email Forward]@row = "0 Days", [Term Date]@row, IF([Duration - Phone/Email Forward]@row = "30 Days", [Term Date]@row + 30, IF([Duration - Phone/Email Forward]@row = "60 Days", [Term Date]@row + 60)))

Cheers,

Genevieve

JohnFesler

Exactly what I needed, Thank you Genevieve!

Genevieve P.

No problem! 🙂