How can you calculate new date off of date fields?

Question

I continue to get an error #INVALID COLUMN VALUE with my formula below.

I have two restricted date fields RFP Decision Date and Actual RFP Award Date. I want to add the Estimated Approval Time, which is a number days value to the Actual RFP Date or if that is blank the RFP Decision Date, where we have a value in the Estimated Approval Time field.

=IF(ISBLANK([Estimated Approval Timeline]@row ), "", IF(ISBLANK([Actual RFP Award Decision Date]@row ), [RFP Decision Date]@row  + VALUE([Estimated Approval Timeline]@row ), [Actual RFP Award Decision Date]@row  + VALUE([New Supplier Brand Approval Est. Timeline (days)]@row )))

Any thoughts?

Nathan Slatton · Accepted Answer

Did you change the column to a Date field instead of Text?