Add date not working

ldavenportHAP

Hey guys.. can anyone help me troubleshoot why this isnt working?

I am looking to add 45 days from the Start Date in 45 Day Prod column but am getting invalid column value.

Paul Newcome

You would use the same thing, but instead of adding 45 you would add Tenure@row.

Paul Newcome

You do not need a DATEONLY function.

=[Start Date]@row + 45

Also double check that both columns are set as date type columns.

Carson Penticuff

Is [Start Date] simply a date entry? If so, you do not need DATEONLY.

[Start Date]@row + 45

If you do need to apply DATEONLY:

DATEONLY([Start Date]@row) + 45

The [45 Day Prod] column must also be formatted as DATE in order for either formula to work.

ldavenportHAP

So i had to change this around a bit to work for our needs and now the @row wont work, any assistance with the updated format below to auto populate Date when a start date is added.

So Start Date + Tenure (Days) = Date

Paul Newcome

You would use the same thing, but instead of adding 45 you would add Tenure@row.