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 :)
Best Answer
-
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.
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
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.
-
Yes the 'task start date' column is defined as a date column
-
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.
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
That has fixed it! Thank you very much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- New program proposals are submitted via a form and collected on Sheet 1. When approved by a team leader, the row is copied to Sheet 2. I want to capture the date the copied occurred, which I thought w…
- I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
- Hi, I'm looking to write a formula using references to a rate sheet (screenshot attached with sensitive information redacted). We have several types of rates here, and also ones that are per word, whi…