Can't add days to a Date

Cemil Binlik

Hi,

It seems like I cannot add days to a date by a formula.

Formula is below:

=[CX Finish Date (F)]@row + 2

And see the Screen shot below, above formula adds the number "2" to the end of the date as a text. However, it is expected to have 2 days added up to the date that was selected.

Thank you in advance.

Cemil Binlik

Kelly, thank you very much, I don't know how I missed this but CX Finish date was not formatted as date regardless it looked in the date format as it is pulling the data from another sheet (linked). I just changed the column properties to date and the initial formula worked. Thank you for the heads up.

Kelly Moore

Hey @Cemil Binlik

Is your [CX Finish Date (F] based on a calculation?

Try this.

=VALUE([CX Finish Date (F)]@row) + 2

Did that work for you?

Kelly

Cemil Binlik

Kelly, thank you very much, I don't know how I missed this but CX Finish date was not formatted as date regardless it looked in the date format as it is pulling the data from another sheet (linked). I just changed the column properties to date and the initial formula worked. Thank you for the heads up.