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!
Help Article Resources
Check out the Formula Handbook template!