I want to calculate a Due Date based on a defined Frequency.

Doris F

Audit frequencies are Annually, Biennially or Triennially. I have used the following formula but I get the #UNPARSEABLE output.

=IF([Audit Frequency]@row=Biennially, "[Last Audit Date]@row+730", IF([Audit Frequency]@row=Triennially, "[Last Audit Date]@row+1095", IF([Audit Frequency]@row=Annually, "[Last Audit Date]@row+365", "N/A")))

Lindsay AR

@Doris F Try this.

=IF([Audit Frequency]@row="Biennially", [Last Audit Date]@row+730, IF([Audit Frequency]@row="Triennially", [Last Audit Date]@row+1095, IF([Audit Frequency]@row="Annually", [Last Audit Date]@row+365, "N/A")))

Lindsay AR

@Doris F Try this.

=IF([Audit Frequency]@row="Biennially", [Last Audit Date]@row+730, IF([Audit Frequency]@row="Triennially", [Last Audit Date]@row+1095, IF([Audit Frequency]@row="Annually", [Last Audit Date]@row+365, "N/A")))

Doris F

@Lindsay AR - THANK YOU!!!