Add days to a date

J.Patel

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 :)

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.

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!