Add days to a date

Hi, I am trying to create a column that adds a certain number of days to a date.

When I use =[Task start date]@row +7 . It doesn't add 7 days to the date, instead just adds the number 7 to the end of the date.

I have also tried to use the WORKDAY formula as an alternative, =WORKDAY(Task start date]10, 5) . This results in a #INVALID DATA TYPE

The 'Task start date' column and 'Task end date' column are both date columns, and i have tried checking and unchecking the box to restrict to dates only in the column properties and get the same issues.

Any help would be much appreciated!

Thanks :)

Find more posts tagged with

Formulas

Accepted answers

Genevieve P.

Hi @J.Patel

How are you entering the date into your Start Date column?

Even though it's set as a Date Column, it looks like your value in the cell is being seen as a Text value, not a date.

All comments

Sameer Karkhanis

Can you please confirm if your "Task start date" column is of Date type? The invalid data type error is most likely as the start date column is not defined as a Date column.

J.Patel

Yes the 'task start date' column is defined as a date column

Genevieve P.

Hi @J.Patel

How are you entering the date into your Start Date column?

Even though it's set as a Date Column, it looks like your value in the cell is being seen as a Text value, not a date.

J.Patel

That has fixed it! Thank you very much!

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.