Hello,

I have a list with a calculated column with =Today()-1 which will give me yesterday's date in the column. I would like to create a Gantt view with the start date of Yesterday and Due Date with the ending date.

It displays the date correctly in the list view but the Gantt view does not read the Yesterday date column. 

Any help would be appreciated.

Thanks!

Hi

From your description, my understanding is that you want to make the start date of yesterday, but you can't choose calculated date as start date.

You can create a new Date and Time column and create an workflow to update list item to update the new date column's value to the calculated column's value.

Then you can choose the new date column as start date.

Best Regards

Lisa Chen