If then statements with date fields

so_tx_anglerette

Hello. I am trying to calculate a date field based on the following manually entered data:

• If "Project status" is not "Cancelled" [drop down field]
• And "Const duration" is not null [text/number field]
• Then add "Const duration" to "Start date" to equal "Completion date"
• For example:
• Start date is 6/21/18 & duration is 2 days = 6/22/18 Completion date

*Note: First day is counted

Any help appreciated. 

Faith Glass-Wilson

Hello,

Try this formula, you may need to edit the column titles, and don't forget to format your date columns.

 

=IF(AND([Project Status]@row <> "Cancelled", [Const Duration]@row <> ""), [Const Duration]@row + [Start Date]@row)