Formula to Use a Date Field and add a Number Field to return new Date

Josh at Schneider

I want to use a calc on a date field, to use one date field and add a number value field to return a new date in the field with calculation.

I am using

=parent([SOO Start]@row+[SOO Day Duration (Calc'd 25%)]@row

But I get an #Unparsable error in the field.

The field I am entering calc on is a date field, [SOO Start] is a date field, and [SOO Day Duration (Calc'd 25%)] is a Text / Number field

Paul Newcome

In that case, try ditching the parent portion along with that opening parenthesis so that all you have is

=[Date Column Name]@row + [Number Column Name]@row

Michelle Choate 2

Is it possible it is because the Calc'd 25% is not a whole number? Could you use the ROUND function to get to a whole number and try that?

Josh at Schneider

That is part of the column name not part of the formula? Could it effect the formula?

Josh at Schneider

I tried rounding that value and it did not correct.

Paul Newcome

What is the reason for the "parent(" at the beginning of your formula? The parent row in your screenshot is blank.

Josh at Schneider

Looking in the community when I was trying to figure out the formula that was a "solution" to use to be able to take a date field and add a number value from another field and return a date field. So that is what I was going with. All I need to do is just that take one date and be able to add and subtract whole number values from another field, and then return it as a date in the field of the formula. In my head this should be easy but just cant get it to work on here.

Paul Newcome

In that case, try ditching the parent portion along with that opening parenthesis so that all you have is

=[Date Column Name]@row + [Number Column Name]@row