Trying to calculate dates

ceej

I'm trying to have smart sheets calculate a new date. I'm using =[EndDate]5+1 but it's not returning a date. What am I missing?

Mike Wilday

Make sure the column you are adding the date to is also set up as a date-column type. You can right-click on the column header to review/edit the column type. Also, what specific error are you getting? 

Mike Wilday

Also make sure your column name is EndDate and not End Date. If your column name has no space, you can just use =EndDate5+1. If it does have a space make sure that matches. =[End Date]5 + 1

 

Paul Newcome

Also make sure that your End Date column is actually a date column.

Mike Wilday

Ceej, any feedback on our suggestions?