Can't add days to a Date

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.

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.