I've recently added a Date column to a Document Library and would like to update all of the existing documents with a calculated date.
The new Date Column [DueDate] can be entered manually on Creation/Edit, but I would need it to Default to 1 Year later than another column called [Date]. Since this needs to be editable, it cannot be a calculated column.
I've already attempted to do calculations in the Default box on the [DueDate] column, but since you can't reference other columns this won't work.
What's the best way to achieve this?